Message Pop up Macros
 

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. :mad:
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? :confused:

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

Message Pop up Macros
 

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" a écrit
dans le message de news:
...

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. :mad:
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? :confused:

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

Message Pop up Macros
 

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!

:confused: :confused:


--
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

Message Pop up Macros
 

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

"penri0_0" wrote in
message ...

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!

:confused: :confused:


--
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

Message Pop up Macros
 

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


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=540999

Message Pop up Macros
 

Solved it. Changed Macro security from High to Medium.

Thanks all for your suggestions


--
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