A
Anthony
Hi All,
Can anyone please help. I have a workbook which protects itself on start
up (removes toolbars, menus, tabs etc.) so the user has to use the buttons
and forms I have created, which works very well on 99.9% of the excel
machines it runs on.
The issues I have on a small number of machines, is the workbook is losing
focus for no reason and causing runtime errors.
This is most noticeable a section I have allowed a password to re-enable
everything I have turned off under the protection. I type the password and
the workbook unlocks but then the workbook.activate function is called and
re-enables the protection.
The workbook.deactivate and workbook.activate run code and either set or
unset the protection.
The workbook loses focus, then re-gains focus causing this problem.
Does anyone know what causing this annoying problem?
Regards
Anthony
Can anyone please help. I have a workbook which protects itself on start
up (removes toolbars, menus, tabs etc.) so the user has to use the buttons
and forms I have created, which works very well on 99.9% of the excel
machines it runs on.
The issues I have on a small number of machines, is the workbook is losing
focus for no reason and causing runtime errors.
This is most noticeable a section I have allowed a password to re-enable
everything I have turned off under the protection. I type the password and
the workbook unlocks but then the workbook.activate function is called and
re-enables the protection.
The workbook.deactivate and workbook.activate run code and either set or
unset the protection.
The workbook loses focus, then re-gains focus causing this problem.
Does anyone know what causing this annoying problem?
Regards
Anthony