Confused about security level for macros

Topic

New Reply

I have a button in a spreadsheet that sorts the data based on a column. When clicked, there is a warning that the macros have been disabled because the security levels are high. When I check Macros | Security…, they’re set to MEDIUM…what am I missing here??

Thanks in advance.

Reply | Quote

Replies

Perhaps the message is misleading.

What Excel version are you using?

Reply | Quote

Perhaps the message is misleading.

What Excel version are you using?

Jan Karel, The subtext of the Title says Excel 2003…..

Reply | Quote

Jan Karel, The subtext of the Title says Excel 2003…..

Gosh, should have spotted that!

Reply | Quote

I have a button in a spreadsheet that sorts the data based on a column. When clicked, there is a warning that the macros have been disabled because the security levels are high. When I check Macros | Security…, they’re set to MEDIUM…what am I missing here??

Are you sure you clicked enable macros when you opened the file?

Reply | Quote

I closed the workbook, reopened it, and enabled the macros…worked that time. Phew. Thanks. Thought I was going nuts (or further nutty than I already am).

Are you sure you clicked enable macros when you opened the file?

Reply | Quote