ShowDataForm problem

MERKY · May 6th, 2002, 01:28 PM

i need to alter this macro so that when it opens up the forms screen it should choose 'Criteria'. Any Ideas?

Sub EDITORDELETE_MEMDATA()
Sheets("Member Database").Select
ActiveSheet.Unprotect
ActiveSheet.ShowDataForm
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

lenze · May 6th, 2002, 01:51 PM

Don't know if this will work, but try

Sendkeys"%C" after the form is opened

MERKY · May 6th, 2002, 01:58 PM

It dosent have any effect.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 01:28 PM	#1
MERKY New Member Join Date: Apr 2002 Posts: 38	i need to alter this macro so that when it opens up the forms screen it should choose 'Criteria'. Any Ideas? Sub EDITORDELETE_MEMDATA() Sheets("Member Database").Select ActiveSheet.Unprotect ActiveSheet.ShowDataForm ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub

May 6th, 2002, 01:51 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Don't know if this will work, but try Sendkeys"%C" after the form is opened

May 6th, 2002, 01:58 PM	#3
MERKY New Member Join Date: Apr 2002 Posts: 38	It dosent have any effect.