Getting rid of introductory screens

  • Thread starter Thread starter KLassman
  • Start date Start date
K

KLassman

In "inherited" a spreadsheet which when you open it up, contains severa
boxes with remarks in them . . . like "Welcome to the Reporting Packag
. . ." . There are 3 of them, and you have to click OK to get pas
each one. I'd really like to get rid of them, but can't seem to fin
out where to do that. They are not headers or footers, there doesn'
seem to be anything in the Page Set Up that would create such pages.
Does anyone know what these might be called so I can research furthe
or can anyone tell me how to get rid of them? I hope they aren't VB
--- as I don't know that at all! Appreciate any help on this
 
Hi KLassman!

The introductory screens are achieved using VBA probable as a
Workbook_Open event subroutine in the ThisWorkbook module.

You'll probably find that the VBA project is password protected
anyway. But if it isn't you might attempt removal.

Alt + F11 activates the Visual Basic Editor
Select the workbook in the project explorer window at top left
Expand the project tree [here's where you may hit the password
protected problem]
Double click ThisWorkbook

You can then view and amend the code.
You're looking for lines such as:
Something.Show

Another alternative is to change your security settings:

Tools > Macro > Security
Change to high
OK

This will disable subroutines but may well disable vital other
subroutines.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you very much for this information! I'll try it when I get t
work tomorrow - and hopefully get rid of these boxes
 
Hi KLassman!

As a last resort, send to me at address below and I'll get rid of
them.

I'm beginning to think that intro screens should have a "use by date"
as they can get to be a PITA!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top