Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Open Event Q
I have some code that will only open a Workbook if a User is listed
within a Named Range. The user is dependent on selecting a dropdown within the file itself, thus "before the workbook is opened" this value will be blank, to counter this I have a formula in the Named Range that says if The User cell is blank, return the applications username, thus it gets past the situation where its the incorrect user temporarily, or so I thought, the Workbook has to Open in order to refresh this formula Any ideas of how I could get around this, in essense anyone should be able to open the file, but when the User is selected, the rules kick in Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Open Event Q
To by-pass the "RULE", set the security level of Excel to enable the by-pass
of all macro functions. -- Gary's Student gsnu200707 "Sean" wrote: I have some code that will only open a Workbook if a User is listed within a Named Range. The user is dependent on selecting a dropdown within the file itself, thus "before the workbook is opened" this value will be blank, to counter this I have a formula in the Named Range that says if The User cell is blank, return the applications username, thus it gets past the situation where its the incorrect user temporarily, or so I thought, the Workbook has to Open in order to refresh this formula Any ideas of how I could get around this, in essense anyone should be able to open the file, but when the User is selected, the rules kick in Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Open Event Q
Hide the sheets and open it to a userform. Put code in the userform to check
the name and if OK unhide the sheets and close the form, otherwise msgbox, You are not unauthorized to open this document. Put an close event that rehides the sheets. Just a thought. Regards, Alan "Sean" wrote in message oups.com... I have some code that will only open a Workbook if a User is listed within a Named Range. The user is dependent on selecting a dropdown within the file itself, thus "before the workbook is opened" this value will be blank, to counter this I have a formula in the Named Range that says if The User cell is blank, return the applications username, thus it gets past the situation where its the incorrect user temporarily, or so I thought, the Workbook has to Open in order to refresh this formula Any ideas of how I could get around this, in essense anyone should be able to open the file, but when the User is selected, the rules kick in Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Event | Excel Discussion (Misc queries) | |||
Need help re VBA for Worksheet Open Event | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming |