• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

excel anoying macro warning

Red Squirrel

Red Squirrel

No Lifer
on this spreadsheet i'm working on, I had to make a macro to create 30 new rows since doing it manually is tedious. Then I deleted the macro. Now every single time I open that document I get an anoying macro warning. It's not as bad as Access where you get literally 3 warnings before opening, but its still really anoying. Any way to fix this at the spreadsheet level? This spreadsheet is going to various people so I dont want them to keep getting this anoying warning.
 
You can digitally sign it and then they just need to accept your documents once. If you make the cert yourself, they may not be able to do that.
 
Tools, Macro, Security, set it to low might work.

EDIt: I think this setting is based on the workstation, not the spreadsheet. Everyone else would have to change this setting to not see the warning.
 
Click in the upper-left cell, the one without a letter or number. Copy & paste the entire sheet on to a new workbook, save as, & try it. The macro warning should be gone.

Worked for me two days ago.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top