Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a form onto a macro - Need help ASAP
Hi
I have made a database and I have a list of customers, what I want to do is for the user to be able to add new customers via through a form (go to data then form on excel 2000), how would I connect this up? every time I try it says there is a bug and I cannot seem to unbug it, maybe I am typing something wrong. This is what I currently have typed: Sub addnewcustomer() ' ' addnewcustomer Macro ' Macro recorded 12/13/2003 by TMO ' ' Range("C5:L23").Select ActiveSheet.ShowDataForm End Sub Is this right? Also, how would I connect a macro to make the page print? Also, can you add password onto excel? if so how. Hope you guys can help me, thanks. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save the formulas when running a macro? Need ASAP!! | Excel Discussion (Misc queries) | |||
macro for form box | Excel Discussion (Misc queries) | |||
How Can I call any form or macro.. | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Making form using Excell Help ASAP! | Excel Discussion (Misc queries) |