Subject: problems with Data Form macro
From: "Jeff Johnston" Sent:
2/20/2004 4:15:13 PM




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. The original message was posted 11:47 am on
February 20th. Thanks in advance.

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

..

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


====================

Otto's answer did not address your problem.

--
Regards,
Tom Ogilvy


"Jeff Johnston" wrote in message
...
Subject: problems with Data Form macro
From: "Jeff Johnston" Sent:
2/20/2004 4:15:13 PM




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. The original message was posted 11:47 am on
February 20th. Thanks in advance.

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

.