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
"Jeff Johnston" wrote in message
...
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

See this KB

http://support.microsoft.com/default...62&Product=xlw
ShowDataForm Method Fails If Data Can't Be Found


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Jeff Johnston" wrote in message ...
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

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.

-----Original Message-----
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
.