This worked perfect and thanks for the clarification.... Much appreciated
--
Thank you, Brenda


"Max" wrote:

The title of the Sub is not relevant
Sub UnhideHerdDescription()

What is relevant is the name of the tab in these lines
Sheets("UnhideHerdDescription").Visible = True
Sheets("UnhideHerdDescription").Select

which needs to match exactly with what's on the tab
(except for case)

Check that the actual name on the tab is really:
UnhideHerdDescription

Then hide that tab, try running your sub again. It should work ok.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---