I'm using the pearson form positioner, but I am getting errors with my locked workbook.
It is erroring on the line with PS
Please Login or Register to view this content.
The error is
Run-time error '1004':
Unable to set the visible property of the Worksheet class
I'm unlocking before and after PS. Do I even unlocked within the PositionForm Function, and it still gives that error? Is there somewhere else in this class I need to unlock?
Last edited by andrew c.; 07-20-2011 at 12:18 PM.
Shouldn't unlocking not even be an issue if I have explicitly unlocked it beforehand in the code. it isn't like just because I called a function, I need to unlock the workbook again right? Or are the class variables locked or something upon opening of the workbook and I need to unlock specifically within that class?
Is the sheet protected as well?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
For me Chip's code works as expected for a protect worbook and or worksheet.
What exactly is Activities in your code?
The sheet is unlocked at the moment, it is just that the workbook is protected.
Activities is a userform.
When I protected the workbook, I chose the option of protecting both structures and windows. Does this affect anything?
So if I declare my protection like this:
Please Login or Register to view this content.
it works??? IDK why I had to specify structure and windows....
Last edited by andrew c.; 07-19-2011 at 05:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks