Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jinvictor
 
Posts: n/a
Default protect the worksheet


I did a excel file for work, what i want is everybody can open it, but
they can't save(save as) or copy it. how can do that?
Thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=538719

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default protect the worksheet


here's one from J-Walk's excel for dummies

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
MsgBox "You Cannot save a copy of this workbook!"
Cancel = True
End If
End Sub

this goes into a workbook module, search excel help if you need to find
it

this won't let you save the workbook when you are in excel......


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538719

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I protect a worksheet but still use ActiveX check-boxes? John Ewald Excel Discussion (Misc queries) 0 February 22nd 06 05:30 PM
password protect worksheet Ben Excel Discussion (Misc queries) 3 February 14th 06 03:30 PM
Protect hide worksheet Lawrence Excel Worksheet Functions 4 December 20th 05 01:48 PM
how to protect excel worksheet and still use the outline buttons? sylvia Excel Worksheet Functions 0 December 6th 05 01:32 PM
lost my password (worksheet protect) Dan Winterton Excel Discussion (Misc queries) 1 January 18th 05 08:09 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"