SECURE Workbook?

[VulcanJedi]

Is there any good / real way to secure a workbook?
I know you can lock cells and password protect files....etc.
All I want is that when people open the file they can edit and do whatever they want....BUT:

NO SAVING PERIOD. Not via buttons...not prompted when exiting.
NO BS SAVE AS feature, no copy/paste the sheet to a new book to rename...if they disables ability to cut/copy/paste so be it.

The form is controlled and has little data entry thanks to code anyhow.

Anybody have good insights/approaches? Either from XL inherently or via VBA? TIA

tranpkp Tranpkp

 

[MattSmithProg]

Hi,

There is a little funtion that may point you in the right direction.

Place this code in the ThisWorkbook module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
SaveAsUI = False
Cancel = True
End Sub

The only problem with this is that you can't save the code for it to work. Catch 22.

You can also disable the Cut/Copy/Paste functionality.

Hope this gives some insight.

Matt Smith

No two nulls are the same

 

[VulcanJedi]

Is that some sort of sick joke?! Tranpkp

 

[MattSmithProg]

Just a little Microsoft humour. This has got to be one of the most useless functions built unless I have completely missed something. Matt Smith

No two nulls are the same

 

[RobBroekhuis]

You could query the keyboard state in the beforesave event, so that it would save if ALT+SHIFT+CONTROL are all pressed... Rob