Modeless Forms In Excel 1

[ColinC]

Anyone know how to create modeless forms in Excel 97? If not, I'm looking for a way to display a message to the user and not let them see the formatting that is happening on the sheets. I've turned ScreenUpdating off but when I select a new sheet it becomes visible. Colin Chevrier
Colin_Chevrier@dmr.ca

 

[rmikesmith]

Colin,

No modeless forms in Excel 97. This feature was introduced with Excel 2000.

If you are able to select a different sheet, then your macro where you set ScreenUpdating = False has completed and ScreenUpdating gets re-set to True. Perhaps you can give more detail on what you are trying to accomplish.

Regards,

M. Smith

 

[ColinC]

I have a database utility written by someone else that exports data to an Excel workbook. The user has requested a workbook that can be used to select the data from the exported workbook and format the data. I wanted a modeless form to display a message to the user while the report was being formatted. I also don't want the user to see the raw data.

Any ideas would be appreciated. Colin Chevrier
Colin_Chevrier@consulting.fujitsu.com

 

[rmikesmith]

Colin,

I have a strategy that I believe may work for you. It involves creating a workbook to serve as the main application (viewable interface and code), which in turn will open and manipulate the workbook containing the exported data. I will send a demo workbook to your email address shortly. I have also seen versions of a progress bar for this situation. If I can locate the code I'll pass this along also.

Regards,
Mike

 

[ColinC]

Thanks Mike your idea works great. I also found a site with info about modeless forms and progress bars at:

http://www.bmsltd.co.uk/Excel/Default.htm

Have a good one. Colin Chevrier
Colin_Chevrier@consulting.fujitsu.com