problems with Data Form macro

  • Thread starter Thread starter Jeff Johnston
  • Start date Start date
J

Jeff Johnston

Having a problem with a macro. Hoping someone can help me
out. I have programmed the macro as follows:

ActiveSheet.Unprotect
Columns("A:J").Select
Selection.EntireColumn.Hidden = False
Range("E27").Select
ActiveSheet.ShowDataForm

but receive the following error message when I try to
execute it:

Run-time Error '1004':

ShowDataForm method of Worksheet class failed.

Basically I want the macro to unprotect my sheet, then
unhide some of the columns I have hidden, then show a
data form for the user to use. If someone can help me it
would greatly be appreciated. Thanks in advance.

Jeff
 
Don't know what you are wanting to do or what you want to happen. If you
have a UserForm that you want to show, use:
MyFormName.Show HTH Otto
 
I posted the following message earlier today and received
a couple of responses from Ron de Bruin & Otto Moehrbach.
Unfortunately when I click on their response all I get
is "Message Unavailable". Could somebody email me their
responses if it shows up for them? It would greatly be
appreciated. Thanks.
 

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

Similar Threads

problems with DataForm macro #2 1
Excel Data Form 2
Print Macro code help 1
Hide / Unhide Columns in Password Protected w/s 2
Make a check box run a macro 5
Copy Paste with fiter and hide copies filtered and hidden 0
Script works in forms element but doesn't in normal option button 2
Help with macro - deja vu 2

Back
Top