unprotecting macros

[Bryan Kelly]

I purchased the book "Microsoft Excel2000 Visual Basic for Applications" and
installed their examples. When I attempt to edit a macro, as instructed in
the boot, the edit button is greyed out and not active. The book says
nothing about this. When I select Tools | Protection, and all the
options, there is nothing to unprotect.

How do I unprotect everything in the worksheet?

 

[Debra Dalgleish]

Under Tools>Macros>Security, is your security level set to Medium?

If it's on High, you won't be able to edit the macros. Set it to Medium,
then close and reopen the workbook, enabling the macros when prompted.

 

[Bryan Kelly]

I don't have Tools | Macros | Security. Under Tools | Macro I find
Macros Alt + F8
Record New Macro
Visual Basic Editor Alt + F11

I am running Excell 97. Anything I can to get get to these macros?

Bryan

 

[Jon Peltier]

Are the Excel 2000 macros protected? If so, you'll never unprotect them
in Excel 97, because Microsoft changed the protection algorithms for
Excel 2000.

Press ALT+F11 to open the VB Editor. Do you see the files in the Project
Explorer pane? (Press CTRL+R to open the Project Explorer.) When you
click on the cross in front of the file, does it expand and show you the
sheets and modules?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Gord Dibben]

Bryan

Excel 97 has no levels of security. Macros are enabled or disabled.

Tools>Options>General. Make sure "allow macros" is checked ON.

Gord Dibben Excel MVP

 

[Guest]

-----Original Message-----
I purchased the book "Microsoft Excel2000 Visual Basic for Applications" and
installed their examples. When I attempt to edit a macro, as instructed in
the boot, the edit button is greyed out and not active. The book says
nothing about this. When I select Tools | Protection, and all the
options, there is nothing to unprotect.

How do I unprotect everything in the worksheet?
--
Bryan Kelly
Time is the medium we use to express out priorities.


Hi Bryan:

Now, I'm not Joe Programmer, but I know one reason
as to why the Edit button grays out.

Since you mentioned installing macros from a book,
there could be duplicate names of a macro. That would
drive Excel crazy and not allow you to Edit. If you
haven't checked for this, I recommend you do so.

I hope this helps.


All the best,

Jeff Bowden
(e-mail address removed)