| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with Data Form macro
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
| Macro to bring up Data Form | Excel Discussion (Misc queries) | |||
| Data Form, Macro and Countif | Excel Worksheet Functions | |||
| Data Entry Form: Macro-One To Many | Excel Discussion (Misc queries) | |||
| Data Form has macro issues | Excel Discussion (Misc queries) | |||
Threaded Mode
