Macro to open a sheet in a new window

[tonywatsonhelp]

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]

Hi,

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