View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tj tj is offline
external usenet poster
 
Posts: 71
Default Macro Enable after Disabled

I have a large spreadsheet with macros. Sometimes when I open this
spreadsheet, the enable/disable dialogue box doesn't appear, and the file is
opened w/out enabling the macros. Is there a way to: 1) make sure dialogue
box always appears; or 2) enable the macros after the file is already open w/
macros disabled (without closing and reopening the file)?

Thanks for the help.