Opening files with macro security

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:49 PM GMT

QuestionEdit

When I open a particular file, it brings up the Macro Security box, requesting to disable or enable macros. No matter which selection I choose, once I get into the actual spreadsheet I cannot find any macros (using the Alt F8) command. My ultimate goal is to get rid of this dialogue box from coming up each time I open the file and not having any macros whatsoever.

AnswerEdit

Slightly annoying one - IF the sheet has EVER had macros, this warning comes up - the only fix I know of is to copy ALL sheets to another workbook, close the original and SaveAs on the new one -this new one will NOT have the warning as it has never had a macro on it!

Advertisement

©2024 eLuminary LLC. All rights reserved.