Neat trick to force users to enable macros.

[Cbrine]

They are both kinda correct. If you change a worksheet to xlsheet veryhidden, this will prompt excel to save, since it was changed. If you have the application.displayalerts set to false, then you will overwrite the workbook. If you don't have displayalerts set to false, you will recieve the prompt to save, with which you can select not to save.

Cal

 

[litrelord]

I sense a fight coming on! i'm not a war-monger - honest!

No, no. No fights here. Like I said, I actually think it's quite a good idea. I just wanted to point out a minor pitfall which could cause problems.

If you don't have displayalerts set to false, you will recieve the prompt to save, with which you can select not to save.

And that's where the problem lies, because then the next person who opens the workbook can do so without macros enabled and not see the message.

Sorry if I came across as rude. It wasn't intentional.

Nick

 

[Tieske8]

New reply to an old post; looking for a solution to this, I ran into this post, but also found a better (imho) one, so I documented it.

I think the discussion here can be overcome by this solution; http://www.thijsschreijer.nl/blog/?p=263

It leave the default 'save' behaviour of Excel alone, so it works as any user would expect it.