Macro to Hyperlink

PeterBrazel · May 21st, 2002, 04:18 AM

Can I attach a macro to a Hyperlink. If so how is it done.

Thanks in advance.

Peter Brazel

dk · May 21st, 2002, 04:29 AM

Hi Peter,

Take a look here:-

http://www.mrexcel.com/board/viewtop...c=4201&forum=2

HTH,
Dan

PeterBrazel · May 21st, 2002, 04:32 PM

I seem to have several problems here. First I want to create a macro that deletes two cells in a record, then fill the record using a data form, then when the user has completed the form I want the macro to take them back to where they were when the started the macro. All this then I want to assign to a hyperlink.

When creating the macro I get a "showdataform method of spreadsheet class failed" error. Plus I am still not quite sure how to get the hyperlink/macro working.

That's a beginner for you.

Also can someone suggest the best method of study for programming this thing. Are there any training CD's and or good books that go into detail.

Thanks in advance.

Peter Brazel (Aus)

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

May 21st, 2002, 04:18 AM	#1
PeterBrazel New Member Join Date: May 2002 Location: Australia Posts: 32	Can I attach a macro to a Hyperlink. If so how is it done. Thanks in advance. Peter Brazel

May 21st, 2002, 04:29 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi Peter, Take a look here:- http://www.mrexcel.com/board/viewtop...c=4201&forum=2 HTH, Dan

May 21st, 2002, 04:32 PM	#3
PeterBrazel New Member Join Date: May 2002 Location: Australia Posts: 32	I seem to have several problems here. First I want to create a macro that deletes two cells in a record, then fill the record using a data form, then when the user has completed the form I want the macro to take them back to where they were when the started the macro. All this then I want to assign to a hyperlink. When creating the macro I get a "showdataform method of spreadsheet class failed" error. Plus I am still not quite sure how to get the hyperlink/macro working. That's a beginner for you. Also can someone suggest the best method of study for programming this thing. Are there any training CD's and or good books that go into detail. Thanks in advance. Peter Brazel (Aus)