data on hidden sheets

G

Gizmo

I have a user form that takes data entered in cells from sheet 1 and deposits
them in cells on sheet 2 and sheet 3 when the add record button is clicked.
If I hide either sheet 2 or 3 I get an error "Select method of worksheet
class failed"

Is there a way to enter data in a hidden sheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top