Password protect macro script
Hey folks,
I've used a similar script to the one below in a previous project. This time I amlooking at adding this piece to a fromatting macro.
I've got a 'Compile Erroe: Expected expression' on the ':='. Any ideas why?
Please Login or Register to view this content.
FileFormat is not a method of the ActiveWindow object.
What is this line of code trying to achieve? I suspect you might want to be using ActiveWorkbook.Save.
Martin
I tried useing the below script within the 'Save file' part of the production script but I get an 'Compile Error: Else without If' and I cant see why.
Any idea?
Please Login or Register to view this content.
You don't need the Else or End If statements as you have the next statement immediately after the 'Then'
I think you need to be using Saveas or SaveCopyAs
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks