View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Petitboeuf Petitboeuf is offline
external usenet poster
 
Posts: 1
Default Disabling SaveAs and Save?


Bob

I am so sorry to bother you again but... well I'm no expert and still
trying real hard to understand that VB thingy :)

So far i have done the following:

1. in the ThisWorkbook code in General I have the Private Sub
Workbook_BeforeSave pasted

2. in the same location I have the Public Sub SaveMyWB pasted

3. I do not know where to put the Public fSave As Boolean as it doesn't
seem to stand alone...


Damn it's hard to be thick!


--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602
View this thread: http://www.excelforum.com/showthread...hreadid=558792