Can i make a workbook protected

Andrew XJ · Mar 18th, 2002, 09:00 AM

I want to protect my workbook so that when user delete the workbook, a message will prompt to the user and warn him on the deletion. How can i do this ? Thx

Regards
Andrew XJ

Andrew XJ · Mar 18th, 2002, 07:35 PM

If can't protect it with a open workbook, can i change some windows setting to protect it? I am using Windows 2000 Pro.

regards
Andrew XJ

NateO · Mar 18th, 2002, 07:42 PM

Andy, through vba the setattr makes the windows property of the workbook read-only. Makes it hard to overwrite in Excel.

Code:

Sub RdOnly()
SetAttr activeworkbook.fullname, vbReadOnly
End Sub

Manually, which you should do with your sys files (unless you update them a lot), right click on the file in your Windows Explorer, select "Properties," and check the read only checkbox.

Hope this helps.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-18 19:00 ]

Mar 18th, 2002, 07:42 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Andy, through vba the setattr makes the windows property of the workbook read-only. Makes it hard to overwrite in Excel. Code: Sub RdOnly() SetAttr activeworkbook.fullname, vbReadOnly End Sub Manually, which you should do with your sys files (unless you update them a lot), right click on the file in your Windows Explorer, select "Properties," and check the read only checkbox. Hope this helps. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-03-18 19:00 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 09:00 AM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	I want to protect my workbook so that when user delete the workbook, a message will prompt to the user and warn him on the deletion. How can i do this ? Thx Regards Andrew XJ

Mar 18th, 2002, 07:35 PM	#2
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	If can't protect it with a open workbook, can i change some windows setting to protect it? I am using Windows 2000 Pro. regards Andrew XJ