Originated From
 Omgili

Posted by Krissy 5 years ago In:

,

Krissy
Krissy Asked:

Embedding Macro in and Excel Workbook

I am very new to creating excel Macros.  I used a guide to create a Insert Date macro. I then inserted a small picture of a calendar and assigned my macro to it.  The function works perfectly fine on my computer, but when viewed on another computer, clicking on the calendar results in the error message "File Personal.xls not found."  I know it is because the macro file must only be saved on my computer and a friend has told me I have to somehow embed the file in the worksheet.  However I have no idea how to do this and have been unable to figure it out.  Any help you can provide would be greatly appreciated.  Thanks!

Liked this question? Tell your friends about it

Answers

SpreadsheetsDirect
SpreadsheetsDirect Answered:

You can either put your macros in Personal.xls which loads up when Excel is started or in the actual book you're working with.  To move it out of the Personal.xls open Excel and press Alt-F11 to bring up Visual Basic.  On the left you should see the Project window with any open files in.  Find Personal.xls and click the + to expand.  Do the same for Modules and find your macro.  Copy the code and find your new book in the Project window and, if needed right click on the filename and select Insert - Module then paste the code into the new module.  You'll will then need to reassign the macro to make it point to the new location.

<a href="" rel="nofollow" cl="http://www.spreadsheetsdirect.com/" class="comlink">http://www.spreadsheetsdirect.com/</a>
Add a comment Report

Related Questions

Other people asked questions on similar topics, check out the answers they received:

davemctavi

Asked: Office home and student 2010. I sent an Excel ...

office home and student 2010. I sent an Excel spreadsheet from work. I can add more info but I can't save the new numbers. Do I have to rename it because of the changes ? How do I do that ?
  • Posted 7 months ago
efi1234

Asked: How do i add macro in excel to button

how do i add macro in excel to button
Jas

Asked: Microsoft Access 2007 macros

I want to automatically add data from one form to another using macros on microsoft access 2007. How do I do that?
  • Posted by Jas 4 years ago

More Questions

Macro to add number to range..HELP!

You'll need a loop to go through cells. Here is my suggestion: Sub AddToCell() 'Do starts a loop Do 'Here is your original macro row ActiveCell.Value = ActiveCell.Value + Val(InputBox("3100", default:=1)) 'Select next cell ActiveCell.Offset(1, 0).Select 'Loop ends here if next cell has no ...

Hi, I am trying write a macros to convert Now ...

well if you use function now the value will change, it's already automatic. Try open blog http://misterahhmad.blogspot.com, there a lot of tips

Date time stamp subtracing in excel

If you have the old date/time in cell A1 and new in A2 put =(A2-A1)*24*60, change format to General and you'll get the total minutes. Take the *60 off to get hours or add *60 to get seconds.

Excel help

Example: =if(a1>b1,"a1 is bigger","b1 is bigger") If the value in the cell A1 is bigger than the value in cell B1 then print "a1 is bigger" otherwise (else) print "b1 is bigger". Once you get the hang of it, it's quite fun to use.