Message Pop up re: Macros

[penri0_0]

Hi,
A spreadsheet i have has suddenly started giving me a message advising me:

'Macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros'

Every time i change data in any cells and then use the Tab or Enter key to move on this pops up.
I haven't recorded any macros and don't understand what might have changed. I though it might be related to a server outage we had, but other spreadsheets are not affected. Is it something within the spreadsheet or Excel itself?

Any help appreciated!

[papou]

Hello
Right-click on your worksheet tab and select view code
Delete all lines appearing in the right window pane.
Exit Visual Basic Editor and save your workbook.

HTH
Cordially
Pascal

"penri0_0" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> Hi,
> A spreadsheet i have has suddenly started giving me a message advising
> me:
>
> 'Macros in this project are disabled. Please refer to the online help
> or documentation of the host application to determine how to enable
> macros'
>
> Every time i change data in any cells and then use the Tab or Enter key
> to move on this pops up.
> I haven't recorded any macros and don't understand what might have
> changed. I though it might be related to a server outage we had, but
> other spreadsheets are not affected. Is it something within the
> spreadsheet or Excel itself?
>
> Any help appreciated!
>
>
> --
> penri0_0
> ------------------------------------------------------------------------
> penri0_0's Profile:
> http://www.excelforum.com/member.php...o&userid=28947
> View this thread: http://www.excelforum.com/showthread...hreadid=540999
>

[penri0_0]

Hi, Tried it but no joy. There is no code in the right hand box under the right-hand drop down General, but there is this under Worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

If i try and delete this it takes me back to the blank General sheet!

[Don Guillett]

delete means to highlight the code and touch the delete key or just
backspace until gone.Then save and try again.

--
Don Guillett
SalesAid Software
[email protected]
"penri0_0" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, Tried it but no joy. There is no code in the right hand box under
> the right-hand drop down General, but there is this under Worksheet.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> End Sub
>
> If i try and delete this it takes me back to the blank General sheet!
>
>
>
>
> --
> penri0_0
>
>
> ------------------------------------------------------------------------
> penri0_0's Profile:
> http://www.excelforum.com/member.php...o&userid=28947
> View this thread: http://www.excelforum.com/showthread...hreadid=540999
>

[penri0_0]

I was doing just that.

It lets me delete, save and go back to the workbook, but the message is still there when i try to change cell content. If i then go back to the code for that sheet it's back again. Do i need to do it for every sheet in the workbook before saving? - My VBA knowledge is limited, i'm afraid!

any other thoughts?!

[penri0_0]

Solved it. Changed Macro security from High to Medium.

Thanks all for your suggestions