I also get the impression on very brief experimentation that workbook_open or
auto_open changes are supplanted by the saved workspace settings. So you
might have to change the zoom for the worksheets after opening the workspace
??? Again, I have no experience with workspaces.
Greg
"Greg Wilson" wrote:
Just a guess that the Auto_Open routine doesn't suspend opening of the other
wbs and so is still executing when the other wbs are being opened (and have
the focus) causing an error. Auto_Open is outdated but still supported and
may not be compatible with workspaces. Try moving it to the ThisWorkbook
module and change the name to "Workbook_Open()" instead.
I confess that I don't use workspaces and I can't test out your situation,
but I thought the code I gave you would work for all computers irrespective
of screen size and resolution since (as I understand) it adjusts the window
zoom for the particular computer so that the selected cell range fits the
screen. I could be dead wrong on this I admit. Suggest you check it out.
Regards,
Greg
"thetoppy" wrote:
Greg, Thank you for your reply,
I need the code to fix zoom levels for different users that access the
file over the network. The reason I have made the code user specific is
because different users have the same resolution but different monitors
and the worksheet doesnt fit on the screen. I know that the code works
when I open any of the workbooks individually and the settings are
perfect on all of the computers I have tested it on. I can't understand
why the module works individually on the workbooks but when I open the
workspace with all three workbooks in it, I get problems. Im not too
strong on my coding but I cannot see a reason for this to happen. Is
there defect within my coding that will cause a problem when multiple
workbooks are open as a workspace?
Thank you so much for you assistance..
--
thetoppy
------------------------------------------------------------------------
thetoppy's Profile: http://www.excelforum.com/member.php...o&userid=33436
View this thread: http://www.excelforum.com/showthread...hreadid=532520