Macro to open a sheet in a new window

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,389
Hi Everyone,
Hope you can help

I want a macro that can open a sheet in a new window.
Idealy it would do this.

When macro is run open Sheet"PDF Views" in new window and
if possible?
place new window in middle of screen taking up about 75% of the screen
make that screen not show any tabs or toolbars but have first screen still do (not so important just would look nice)

Then I need another macro to close this window.

can this be done?
if so please help, any ideas would be helpful

Thanks

Tony
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Are you looking for a ' new Window ' or for a Userform ...?
 

Forum statistics

Threads
1,086,116
Messages
5,387,921
Members
402,088
Latest member
poppa57

Some videos you may like

This Week's Hot Topics

Top