Make sure you always have at least one visible sheet.

(maybe you're trying to hide the last visible sheet.)

Natalie wrote:

It is showing Runtime error 1004.

The macro hides 5 worksheets, and if the sheets are already hidden, and the
button is pressed again this is the error that appears.

"Bob Phillips" wrote:

Can we see the code, and where it errors?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Natalie" wrote in message
...
Hi,

I am creating a spreadsheet for different people to look at, and I have
added a macro button to change the view for each group of people.

However, if it is already on the view they want, and they press it again,
it
is coming up with an error. Is there anyway I can get the error to not
come
up, and just ignore it that the button has been pressed?




--

Dave Peterson