Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Splash screen and various screen resolutions

Not sure if i should be posting here as the answer i need
is without macros, but anyway...

I have a splash screen that shows if the user has disabled
macros. instructing them to enable them to use this
workbook.

I have a problem in that although everything looks good on
my pc, another user with a different screen resolution
will not see the full message.

Does anyone know a way around this problem?
(Please don't say - write a macro to sort it. )

I have tried reducing the zoom of the spreadsheet so that
the lower resolution is ok, but people will have trouble
reading this on the higher resolution.

I'm hoping someone has a way around this or has come
across this before. All the solutions i have seen are
macros (but they are disabled on my workbook)

thanks for looking
George
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Splash screen and various screen resolutions

Hi George

Is your splash screen a worksheet ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George J" wrote in message ...
Not sure if i should be posting here as the answer i need
is without macros, but anyway...

I have a splash screen that shows if the user has disabled
macros. instructing them to enable them to use this
workbook.

I have a problem in that although everything looks good on
my pc, another user with a different screen resolution
will not see the full message.

Does anyone know a way around this problem?
(Please don't say - write a macro to sort it. )

I have tried reducing the zoom of the spreadsheet so that
the lower resolution is ok, but people will have trouble
reading this on the higher resolution.

I'm hoping someone has a way around this or has come
across this before. All the solutions i have seen are
macros (but they are disabled on my workbook)

thanks for looking
George



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Splash screen and various screen resolutions


Hi George

Is your splash screen a worksheet ?

Stupid question from me (sunday)

Without a macro not possible as far as i know to do this.



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi George

Is your splash screen a worksheet ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George J" wrote in message ...
Not sure if i should be posting here as the answer i need
is without macros, but anyway...

I have a splash screen that shows if the user has disabled
macros. instructing them to enable them to use this
workbook.

I have a problem in that although everything looks good on
my pc, another user with a different screen resolution
will not see the full message.

Does anyone know a way around this problem?
(Please don't say - write a macro to sort it. )

I have tried reducing the zoom of the spreadsheet so that
the lower resolution is ok, but people will have trouble
reading this on the higher resolution.

I'm hoping someone has a way around this or has come
across this before. All the solutions i have seen are
macros (but they are disabled on my workbook)

thanks for looking
George





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Splash screen and various screen resolutions

Yes

All other sheets are hidden until macros are enabled.
-----Original Message-----
Hi George

Is your splash screen a worksheet ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George J" wrote in

message ...
Not sure if i should be posting here as the answer i

need
is without macros, but anyway...

I have a splash screen that shows if the user has

disabled
macros. instructing them to enable them to use this
workbook.

I have a problem in that although everything looks good

on
my pc, another user with a different screen resolution
will not see the full message.

Does anyone know a way around this problem?
(Please don't say - write a macro to sort it. )

I have tried reducing the zoom of the spreadsheet so

that
the lower resolution is ok, but people will have trouble
reading this on the higher resolution.

I'm hoping someone has a way around this or has come
across this before. All the solutions i have seen are
macros (but they are disabled on my workbook)

thanks for looking
George



.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default Splash screen and various screen resolutions

Hi George

You should be able to sqeeze that information onto a 640 * 480 screen. The
only no-code solution I know is to design for the smallest screen and accept
the fact that high-resolution users deliberately chose to be one to see tons
of tiny information sinoultaneously.

Best wishes Harald

"George J" skrev i melding
...
Yes

All other sheets are hidden until macros are enabled.
-----Original Message-----
Hi George

Is your splash screen a worksheet ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George J" wrote in

message ...
Not sure if i should be posting here as the answer i

need
is without macros, but anyway...

I have a splash screen that shows if the user has

disabled
macros. instructing them to enable them to use this
workbook.

I have a problem in that although everything looks good

on
my pc, another user with a different screen resolution
will not see the full message.

Does anyone know a way around this problem?
(Please don't say - write a macro to sort it. )

I have tried reducing the zoom of the spreadsheet so

that
the lower resolution is ok, but people will have trouble
reading this on the higher resolution.

I'm hoping someone has a way around this or has come
across this before. All the solutions i have seen are
macros (but they are disabled on my workbook)

thanks for looking
George



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Discussion (Misc queries) 5 October 26th 05 10:10 PM
Restoring Screen Resolutions adam99[_4_] Excel Programming 3 July 11th 04 12:42 PM
How to position form in same place with different screen resolutions Joe 90[_2_] Excel Programming 5 May 6th 04 10:27 AM
Resizing BackgroundPicture Gifs programmatically for varying screen resolutions Charles Jordan Excel Programming 4 April 13th 04 06:53 PM
different screen resolutions Rob Excel Programming 0 December 10th 03 09:48 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"