Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enable Macro's when accidentally Disabled

Status
Not open for further replies.

cawash

Technical User
Jul 11, 2002
2
0
0
US
I had accidentally clicked the Disable on the macros and now I can't get the macros to work. (on any of my spreadsheets, not just the one I disabled)

I checked the secruity and it was on medium so now I don't know where to go or what to do. Help did not give me any solutions.

help if you can

TIA
 
If you do the following it will give you the macro prompt again.

Click Tools Menu
Select options
Click the General Tab
Check the box that says Macro Virus Protection.
Then OK

If you now open a spreadsheet with Macros this will now allow you to enable them.

Dave David Lerwill
"If at first you don't succeed go to the pub"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top