vba Excel save

[harrisonb]

Hi

Ive written a code that saves under a automatically generated file name, and it works quite happily on a button. Is there a way to disable the 'normal' save button and file save and file save as?

Would have to be just for this spreadsheet, it will be being used on lots of computers.. or to make them run my code one of the two lol

Thanks

Ben

[RobDog888]

Yes but with conditions. If they open or add new workbooks/sheets in your workbook then they
too will have the same restrictions.

You need to create events for activation of workbook, new book added, book opened, etc. to try to show/hide your
menus/toolbar buttons. It may get a bit sketchy but can be done. Mid to Advanced coding depending on your level.

I think I wrote something similar already, let me search for it, probably in CodeBank

[RobDog888]

Found it.

Create Excel Events