View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trying Hard
 
Posts: n/a
Default Macro in "This Workbook"

Hello,

I actually have two questions.
I have, tried, to create a macro in "This Workbook", when I became
dissatisfied with it I simply deleted it. The problem is even though this
macro does not exist in "This Workbook" I still get a prompt (when opening)
that asks if I want to enable macro's.

Q1: How can I eliminate this?


The reason I tried to eliminate it is I recorded the macro that was supposed
to, unprotect the workbook / unhide a page, the macro is erroneous though; it
looks like this:

' Keyboard Shortcut: Ctrl+Shift+U
'
ActiveWorkbook.Unprotect
Sheets("2005 Summary, Exhaustive").Visible = True
End Sub

The macro would work perfectly if when I hit the shortcut key's it would:
unprotect the workbook / unhide a sheet named "2005 Summary, Exhaustive" /
and automatically return the protection settings back when the user closes
the file.

Q2: Can this be done, if so how?


Thanks for any help!

--
Thank you,

Trying Hard