Thread
:
Before Save as Event needed
View Single Post
#
2
Posted to microsoft.public.excel.programming
Frank Kabel
external usenet poster
Posts: 3,885
Before Save as Event needed
Hi
I'm not sure what you're problem is. What error did you get?
--
Regards
Frank Kabel
Frankfurt, Germany
wrote:
Hi!
-I have a Workbook.
-This Workbook, Workbook_Open() --- reads the Computer
Get_Drive_Serial & DiskVolumeId, to Check if the computer belogs to
Our Company.
-If Yes Unhides and Unprotects some of the Sheets "Hidden & Protected
with Workbook_BeforeSave Macro Event.
-When a new Computer open this file, there are no visible Sheets, the
Workbook_Open Reads the desired variables and if the workbook does
not
have then in a database, always protected and hidden with:
Sheets("XXX").Visible = xlSheetVeryHidden
Request for a Password.
If the Password is OK, adds a New computer's DiskVolumeId... to Our
Database.
Everything worked Fine, but When I press Save As stead of Save,
EveryThing goes to the Rubbish!
Because there is not: Private Sub Workbook_BeforeSave """AS"""(ByVal
SaveAsUI As Boolean, Cancel As Boolean)
Any Help????
Many Thanks, for previous questions replies!!!
Reply With Quote
Frank Kabel
View Public Profile
Find all posts by Frank Kabel