I guess you're probably right..! :) I only really needed this to help the
user check that the code to alter the screen zoom depending on the active
resolution when the workbook was opened, actually wored - and it does!

Thanks for your help - sorry about only replying now - I was on leave on
Friday afternoon!

Regards

Pete

"keepITcool" wrote:


I think users can manager their own screen res, so i would never use
your code..it was a quick fix. i dont want to really think about this.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Peter Rooney wrote :

KeepITCool,

I tried both versions - as you pointed out, the shorter one left the
applet behind the window, but with the longer solution, I STILL end
up in the VB editor!

Any more thoughts?

My worksheet is called "Database", here's what I have at the moment...

Cheers

Pete