Startup Application

**aman1234** · 02-24-2009, 10:34 AM

Hi All

I have developed an application in excel/vba which consists of many forms.I have setup the startup form too. when I run the application,on the background ,excel sheet with data appears. I want to run the application with no background data. The background should be plain..

Could you please help me to solve my problem
Regards
Aman

**Cheeky Charlie** · 02-24-2009, 10:37 AM

Simple way:
In the workbook_open event, hide all the relevant sheets and show the startup

Complex way:
In the workbook_beforesave event hide all the relevant sheets and show the startup, then if the workbook is not being closed show everything as it was before.

CC

**aman1234** · 02-24-2009, 10:59 AM

can't figure it out yet

**aman1234** · 02-25-2009, 07:26 AM

Hi Charlie

I got some problem when i hide all the relevant sheets in the workbook_open even and showed the startup sheet.
The problem is when I hide all the sheets and run the project then the forms that refer to those sheets display an error message e.g if I have hidden sheet3 and I run the project then the eror message comes up is "Printout method of worksheet class failed"

Could you please help me to resolve this problem

Regards
Aman

Originally Posted by Cheeky Charlie

Simple way:
In the workbook_open event, hide all the relevant sheets and show the startup

Complex way:
In the workbook_beforesave event hide all the relevant sheets and show the startup, then if the workbook is not being closed show everything as it was before.

CC