Macro for Ungrouping Presentation
Hello,
I am trying to write a macro that would take all the images in a
presentation and ungroup them. However, I cannot get it to work correctly.
Here is the code:
Sub UngroupTheOLEs()
Dim oSlides As Slides
Dim oSld As Slide
Dim oShapes As Shapes
Dim oShp As Shape
Dim oShapeRange As ShapeRange
Set oSlides = ActiveWindow.Presentation.Slides
For Each oSld In oSlides
Set oShapes = oSld.Shapes
For Each oShp In oShapes
If oShp.Type = msoEmbeddedOLEObject Or oShp.Type =
msoLinkedOLEObject Then
Set oShapeRange = oShp.Ungroup
oShapeRange.Group
End If
Next oShp
Next oSld
End Sub
I ran through the Step-In process and the compiler appears to be skipping
the actual ungrouping code. Anyone have a suggestion?
|
0 |
|
Utf
6/4/2010 8:10:43 PM
powerpoint
2011 articles. 
0 followers.
0 Replies
2515 Views
Similar Artilces:
custom views / macros
In creating a custom view from a master document, I manually hid every third row for 1000 rows (whew), assigned a custom view name, added a macro to to show only a particular heading for that view, and assigned a shortcut (cntrl-L). The worksheet was saved as a template. The file was then resaved with a new name and cells filled with desired info. Pressing cntrl-L worked a few times, then suddenly, the view no longer had every third row hidden, though the heading macro still worked. 1. I don't know why it suddenly stopped working and 2. can you help me write a macro that hides...
but there is no macro....
When I open one of my workbooks it warns me there is a macros. No usually a problem except that there are no macros in this work boo that I can find! I email the excel workbook to other organisations, some of which canno accept macros through their security system. This causes tonnes of extr work so I'd be really grateful for any help on how to resolve this. We are on excel xp (2002 SP3) Many thanks sa -- grr ----------------------------------------------------------------------- grrr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1571 View this thre...
Macro Delete/Replace Worksheets
Hi, I created a macro that filters data from a column into seperate worksheets. When I enter new data into the column and run the macro again, I get a Run Time Error '1004'. Can someone help me write a code that either replaces or deletes the previous worksheets? Thanks. Post the macro that's giving you the problem. Gord Dibben MS Excel MVP On 5 Jan 2007 13:20:09 -0800, "eric.nguyen312@gmail.com" <eric.nguyen312@gmail.com> wrote: >Hi, I created a macro that filters data from a column into seperate >worksheets. When I enter new data into the column a...
Macro run on list box change how to
I have a Macro that will change the colour of a connector depending on the custom prop.wiretype How can I have this macro run every time the list box is changed Sub WireType() Dim vsoShape1 As Visio.Shape Dim intPropRow2 As Integer Set vsoShape1 = Application.ActiveWindow.Selection(1) intPropRow2 = 0 If vsoShape1.CellsSRC(visSectionProp, intPropRow2, visCustPropsValue).FormulaU = """Video""" Then Application.ActiveWindow.Selection(1).CellsSRC(visSectionObject, visRowLine, visLineColor).FormulaU = "2" ElseIf vsoShape1.CellsSRC(v...
How can I update macro to delete zero amount columns?
I have a spreadsheet that contains columns with text (such as name, job title, hire date, etc.) and several columns with amounts. I want to delete the "amount" columns that contain all zeros. I used the macro below and it removed all the amount columns that contained just zeros but it also removed the columns that contained the name, title, etc. How can I change the macro below to remove only the zero amount columns and leave the other text columns? Thanks for the assistance. Sub RemoveColumns() Dim nLastColumn As Long Set r = ActiveSheet.UsedRange nLastColumn =...
Writing a Macro
I am creating a form in Microsoft Word 2003. There is an area that requests a physical company information, including; Address: City, State, Zip: Phone: Fax: Primary Contact: Email: I would like to make it so that when a box labeled 'same as physical address' is checked that the information that has been entered will autofill to corresponding fields labeled Billing Information, with the following fields: Address: City, State, Zip: Phone: Fax: Primary Contact: Email: Can anyone help me with this? See the Repeating Data page of Greg Maxey's website ...
Macro
I have 7 identical files which I routinely save to another drive and remove the links. I've recorded a macro that will move the files, but I have to edit it each time to adjust the name of the file. Can the macro be adjusted to move the active file instead of specifying the name of the file? Here's the macro as I currently have it recorded: (This is MPA Attorney, but I would save MPA Agency next, then MPA Internal, etc.. ActiveWorkbook.SaveAs Filename:= "I:\EXLDATA\Loan Recovery MIS\2004_03\Outstandings\MPA Attorney.xls", FileFormat:=xlNormal, Password:=...
Fixing a macro
I've had a macro in place, that permitted me to print a group of columns. Over a period of time, comments were added to my spread sheet (the little red triangles in the corner) Since then the macro will not work. I've tried to remove all the macros. Maybe I haven't because I can't get the macro to work. Is a way that I can copy the macro and the error message for you to see so it may be repaired. As you can probably tell, I don't know how to make a macro. Thanks, Tim fm CT If you want to remove the code, make a...
entering cell text from a macro
What is the format for entering text in a cell from a macro? Range("A1").Value="HERMAN" <hjg57@bellsouth.net> wrote in message news:nIGHg.2893$C6.134@bignews1.bellsouth.net... > What is the format for entering text in a cell from a macro? > > ...
Macro Help #19
I'm sure this will be a Macro: I have several sheets with a workbook that contain part numbers. If a part number = X, then place an employee number in the next column directly beside the part number column. NOTE: Part numbers vary from column to column throughout the work book. Thanks for your help!! Have a look in VBA help index for FINDNEXT. There is a good example you can modify. -- Don Guillett SalesAid Software donaldb@281.com "DNA" <dnoel@fsgbank.com> wrote in message news:54a55c91224f8f183cb297aa2bef0723@localhost.talkaboutsoftware.com... > I'm sure...
Word 2007 Macros
Hello! I am trying to learn about programming Word 2007 macros. (Not recording, actually programming.) I have some experience with VB.NET, but not VBA. Does anyone know of a good resource to help me get started? Thanks! Kaiti Perhaps I should explain the task at hand: I have a Perl script that dumps data from a number of database tables into formatted .pm files. What I need to do, is to take the data from these files, format it (mostly in tables) and add it to a .docx file created from a template I have. I am hoping to use a macro in Word to do this. As I have no experien...
Close Adobe Acrobat Opened by Macro
Hello, I have an excel workbook and in it is a macro that takes one of the sheets and creates a pdf file from it. Once the pdf is created, it is displayed on screen in the Adobe Acrobat program. Is there a way to close the Adobe Acrobat program within the macro so when it is finished I'm back at the worksheet I started in? (the one I ran the macro to create the pdf in the first place) Any help would be greatly appreciated. Thanks!!!! Michelle ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly fr...
enter data in cell then run macro automatically
Hi, Is it possible that I can enter data into a cell and then the pressing of the enter key will cause a macro to run? Rick Yes. That type of macro is run from Event code. For more on events see Chip Pearson's site at http://www.cpearson.com/excel/events.htm Or David McRitchie's site at http://www.mvps.org/dmcritchie/excel/event.htm Gord Dibben Excel MVP On Tue, 25 Jan 2005 21:04:42 -0000, "R D S" <RDS@members.v21.co.uk> wrote: >Hi, > >Is it possible that I can enter data into a cell and then the pressing of >the enter key will cause a macro to...
Excel Macro Question about Conditional Formatting
I have a cell that is colored according to a conditional formatting statement. I want to copy the color to another cell using a macro but I can't find the property. In particular, Range.Interior.ColorIndex is NOT set. I can examine the colors using Range.FormatConditions(index) ..Interior.ColorIndex but I can't tell what value to use for "index" (a conditional format has up to 3 conditions and thus index is a number between 1 and 3 but I don't know which one is currently active). -- Message posted via http://www.officekb.com hi, you are coping the conditional format t...
Macro help #10
Hi! I have a table with customers that have made multiple purchases of different products. I would like to have a macro that creates a purchase number based on the number of times they have purchased individual items. For example, the first time they purchase Product A a 1 would go in this new field, the second time they purchase ProductA a 2 would go in this field. I understand this would work through a date loop but I am lost as to how to accomplish this. I am not really familiar with writing macro's! Another key thing is that in order for it to be a purchase it must not have been a sam...
Toggle Font Styles Macro
I'm trying to write a Macro that toggles through background color and font styles. No one's been able to help me out from my previous posts, so I'm still searching. I need a function that returns the current selection's font style (red, italic, bold, times roman, etc.) so that I can store it in a variable before my toggle begins and so that I can restore the style at the end of my toggle. Can anyone please help me out with this? Here's my code: ' Toggles the background color ' Keyboard Shortcut: Ctrl+Shift+O Sub BackgroundToggle() If Selection.Interior.ColorInde...
Macro help?
Hi all, I am looking for some code that will allow me to enter the current time into a cell by using a shortcut key...(Ctrl+T for example). Or possibly by using a button. I've never used a button before but I'm sure I can figure it out. Any insight? Thanks in advance. ctrl+shift+semi-colon for time ctrl+semi-colon for date -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Ken" <kpaul1@prexar.com> wrote in message news:0ab601c34bdf$ccd5a6d0$a001280a@phx.gbl... > Hi all, > > I am looking for some code that will allow me to enter the ...
Macro security message pop up
Is there any way I can have the security message not pop up that asks t disable macros? This usually comes up if the security level is high. also have the excel cells password protected, but not sure if tha impacts the warning or not. Thanks -- sgods ----------------------------------------------------------------------- sgodse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457 View this thread: http://www.excelforum.com/showthread.php?threadid=27253 Hi if you set the security level to 'Low' you won't get these warning message. BUT I wouldn'...
Recorded macros not working using the shortcut keys
Hello, I have recorded two macros that work fine except they do not run using the shortcut keys I defined. I've stepped through the macros and the shortcut keys are in the scripts, but I can only run them by pulling up the list of macros and selecting the macro and clicking run. I'm using Office 2007 in XP. TIA, Robert When you pull up the list of Macros and select your macro, go to the options box and create a shortcut key. On Fri, 13 Feb 2009 06:11:40 -0800 (PST), CurlyDave <davesexcel@gmail.com> wrote: >When you pull up the list of Macros and select your macro, go to...
Macros and deleting a column
I've got a "contents" sheet which has numerous buttons which take users to a cell on a separate worksheet. I'd like to delete some of the columns in the worksheet as they are no longer needed. When I do this however the macro doesn't amend to the new cell reference. There's a lot of coulmns to delete and a lot of macros that won't work. Any ideas gratefully received. Hi you may post the relevant part of your macro -- Regards Frank Kabel Frankfurt, Germany "Blackcat" <Blackcat@discussions.microsoft.com> schrieb im Newsbeitrag news:F757F808...
copy paste Macro
I was wondering if it is possible to make a macro do the following. copy selected cell, move to another cell (same row) and copy change worksheets seach a column for the first copied value moe 4 cells from the cell it had found in the search then paste the second value Is it possible?? --- Message posted from http://www.ExcelForum.com/ Olark, Yes. Put this in a regular module: (paste it from here, but watch for line feeds). Dim Data1, Data2 Sub Copy1() Data1 = Selection.Value Application.StatusBar = "Data1: " & Data1 End Sub Sub Copy2() Data2 = Selection.Value Applicat...
how to record macro to roll over monthly data
hi , I need to create /record a macro to roll over a monthly data ,each month the 3 month ago figures must be added to the YTD.The remining data must be then moved one month ahead allowing space to include the new figures Thanks Anna Your description gives no idea of the overall structure and you are unlikely to get an answer better than Tools>Macro>Record new macro an record yourself taking the steps, but this is rarely repeatable each month as data is in different cells, etc. It sound like you may need an application written, but without stating yourself and trying to compl...
Protecting macros
I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received when you protect the sheet, ensure edit objects is not selected "Alec Mclintock" <Alec Mclintock@discussions.microsoft.com> wrote in message news:9D22B5E4-21A2-4477-9762-645C0A2DD504@microsoft.com... > I have a protected sheet with buttons assigned to macros. Howver the > buttons > are not protected and can be reassigned by a user using the R mouse menu. ...
Fill in fields with parameters values from macro?!
Hello, I have three letters that I need to send out on a regular basis. I want to have an Office application (Excel) call the word document and fill in the Company name and address. I need to have a Word VBA macro that can receive parameters and then substitute them in a document. I know Excel VBA very well, but not sure how to do this in Word. Question ====== How do you write a Word VBA Macro that can receive parameters and then subtitute fields in a document with the parameter values? For example: (Word VBA) Sub ChangeAddress(byRef CompanyName as string, Address...
excel 4.0 macro remover tool
Dear all, i am looking for excel 4.0 macro removal tool from excel 97 file.Actually we are facing such problem from two months and it gives pain.some excel files contain macro of excel 4.0 with "very hidden and very protective" attribute so that we cannot remove it.i have searched on net and found that there are some tools called macro remover which can remove all types of macros from excel file including excel 4.0 macro from excel 97 file,but it charges which i cannot afford.so if there any tool that can remove particular excel 4.0 macro from excel 97 file please let me know...
In creating a custom view from a master document, I manually hid every third row for 1000 rows (whew), assigned a custom view name, added a macro to to show only a particular heading for that view, and assigned a shortcut (cntrl-L). The worksheet was saved as a template. The file was then resaved with a new name and cells filled with desired info. Pressing cntrl-L worked a few times, then suddenly, the view no longer had every third row hidden, though the heading macro still worked. 1. I don't know why it suddenly stopped working and 2. can you help me write a macro that hides...
but there is no macro....
When I open one of my workbooks it warns me there is a macros. No usually a problem except that there are no macros in this work boo that I can find! I email the excel workbook to other organisations, some of which canno accept macros through their security system. This causes tonnes of extr work so I'd be really grateful for any help on how to resolve this. We are on excel xp (2002 SP3) Many thanks sa -- grr ----------------------------------------------------------------------- grrr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1571 View this thre...
Macro Delete/Replace Worksheets
Hi, I created a macro that filters data from a column into seperate worksheets. When I enter new data into the column and run the macro again, I get a Run Time Error '1004'. Can someone help me write a code that either replaces or deletes the previous worksheets? Thanks. Post the macro that's giving you the problem. Gord Dibben MS Excel MVP On 5 Jan 2007 13:20:09 -0800, "eric.nguyen312@gmail.com" <eric.nguyen312@gmail.com> wrote: >Hi, I created a macro that filters data from a column into seperate >worksheets. When I enter new data into the column a...
Macro run on list box change how to
I have a Macro that will change the colour of a connector depending on the custom prop.wiretype How can I have this macro run every time the list box is changed Sub WireType() Dim vsoShape1 As Visio.Shape Dim intPropRow2 As Integer Set vsoShape1 = Application.ActiveWindow.Selection(1) intPropRow2 = 0 If vsoShape1.CellsSRC(visSectionProp, intPropRow2, visCustPropsValue).FormulaU = """Video""" Then Application.ActiveWindow.Selection(1).CellsSRC(visSectionObject, visRowLine, visLineColor).FormulaU = "2" ElseIf vsoShape1.CellsSRC(v...
How can I update macro to delete zero amount columns?
I have a spreadsheet that contains columns with text (such as name, job title, hire date, etc.) and several columns with amounts. I want to delete the "amount" columns that contain all zeros. I used the macro below and it removed all the amount columns that contained just zeros but it also removed the columns that contained the name, title, etc. How can I change the macro below to remove only the zero amount columns and leave the other text columns? Thanks for the assistance. Sub RemoveColumns() Dim nLastColumn As Long Set r = ActiveSheet.UsedRange nLastColumn =...
Writing a Macro
I am creating a form in Microsoft Word 2003. There is an area that requests a physical company information, including; Address: City, State, Zip: Phone: Fax: Primary Contact: Email: I would like to make it so that when a box labeled 'same as physical address' is checked that the information that has been entered will autofill to corresponding fields labeled Billing Information, with the following fields: Address: City, State, Zip: Phone: Fax: Primary Contact: Email: Can anyone help me with this? See the Repeating Data page of Greg Maxey's website ...
Macro
I have 7 identical files which I routinely save to another drive and remove the links. I've recorded a macro that will move the files, but I have to edit it each time to adjust the name of the file. Can the macro be adjusted to move the active file instead of specifying the name of the file? Here's the macro as I currently have it recorded: (This is MPA Attorney, but I would save MPA Agency next, then MPA Internal, etc.. ActiveWorkbook.SaveAs Filename:= "I:\EXLDATA\Loan Recovery MIS\2004_03\Outstandings\MPA Attorney.xls", FileFormat:=xlNormal, Password:=...
Fixing a macro
I've had a macro in place, that permitted me to print a group of columns. Over a period of time, comments were added to my spread sheet (the little red triangles in the corner) Since then the macro will not work. I've tried to remove all the macros. Maybe I haven't because I can't get the macro to work. Is a way that I can copy the macro and the error message for you to see so it may be repaired. As you can probably tell, I don't know how to make a macro. Thanks, Tim fm CT If you want to remove the code, make a...
entering cell text from a macro
What is the format for entering text in a cell from a macro? Range("A1").Value="HERMAN" <hjg57@bellsouth.net> wrote in message news:nIGHg.2893$C6.134@bignews1.bellsouth.net... > What is the format for entering text in a cell from a macro? > > ...
Macro Help #19
I'm sure this will be a Macro: I have several sheets with a workbook that contain part numbers. If a part number = X, then place an employee number in the next column directly beside the part number column. NOTE: Part numbers vary from column to column throughout the work book. Thanks for your help!! Have a look in VBA help index for FINDNEXT. There is a good example you can modify. -- Don Guillett SalesAid Software donaldb@281.com "DNA" <dnoel@fsgbank.com> wrote in message news:54a55c91224f8f183cb297aa2bef0723@localhost.talkaboutsoftware.com... > I'm sure...
Word 2007 Macros
Hello! I am trying to learn about programming Word 2007 macros. (Not recording, actually programming.) I have some experience with VB.NET, but not VBA. Does anyone know of a good resource to help me get started? Thanks! Kaiti Perhaps I should explain the task at hand: I have a Perl script that dumps data from a number of database tables into formatted .pm files. What I need to do, is to take the data from these files, format it (mostly in tables) and add it to a .docx file created from a template I have. I am hoping to use a macro in Word to do this. As I have no experien...
Close Adobe Acrobat Opened by Macro
Hello, I have an excel workbook and in it is a macro that takes one of the sheets and creates a pdf file from it. Once the pdf is created, it is displayed on screen in the Adobe Acrobat program. Is there a way to close the Adobe Acrobat program within the macro so when it is finished I'm back at the worksheet I started in? (the one I ran the macro to create the pdf in the first place) Any help would be greatly appreciated. Thanks!!!! Michelle ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly fr...
enter data in cell then run macro automatically
Hi, Is it possible that I can enter data into a cell and then the pressing of the enter key will cause a macro to run? Rick Yes. That type of macro is run from Event code. For more on events see Chip Pearson's site at http://www.cpearson.com/excel/events.htm Or David McRitchie's site at http://www.mvps.org/dmcritchie/excel/event.htm Gord Dibben Excel MVP On Tue, 25 Jan 2005 21:04:42 -0000, "R D S" <RDS@members.v21.co.uk> wrote: >Hi, > >Is it possible that I can enter data into a cell and then the pressing of >the enter key will cause a macro to...
Excel Macro Question about Conditional Formatting
I have a cell that is colored according to a conditional formatting statement. I want to copy the color to another cell using a macro but I can't find the property. In particular, Range.Interior.ColorIndex is NOT set. I can examine the colors using Range.FormatConditions(index) ..Interior.ColorIndex but I can't tell what value to use for "index" (a conditional format has up to 3 conditions and thus index is a number between 1 and 3 but I don't know which one is currently active). -- Message posted via http://www.officekb.com hi, you are coping the conditional format t...
Macro help #10
Hi! I have a table with customers that have made multiple purchases of different products. I would like to have a macro that creates a purchase number based on the number of times they have purchased individual items. For example, the first time they purchase Product A a 1 would go in this new field, the second time they purchase ProductA a 2 would go in this field. I understand this would work through a date loop but I am lost as to how to accomplish this. I am not really familiar with writing macro's! Another key thing is that in order for it to be a purchase it must not have been a sam...
Toggle Font Styles Macro
I'm trying to write a Macro that toggles through background color and font styles. No one's been able to help me out from my previous posts, so I'm still searching. I need a function that returns the current selection's font style (red, italic, bold, times roman, etc.) so that I can store it in a variable before my toggle begins and so that I can restore the style at the end of my toggle. Can anyone please help me out with this? Here's my code: ' Toggles the background color ' Keyboard Shortcut: Ctrl+Shift+O Sub BackgroundToggle() If Selection.Interior.ColorInde...
Macro help?
Hi all, I am looking for some code that will allow me to enter the current time into a cell by using a shortcut key...(Ctrl+T for example). Or possibly by using a button. I've never used a button before but I'm sure I can figure it out. Any insight? Thanks in advance. ctrl+shift+semi-colon for time ctrl+semi-colon for date -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "Ken" <kpaul1@prexar.com> wrote in message news:0ab601c34bdf$ccd5a6d0$a001280a@phx.gbl... > Hi all, > > I am looking for some code that will allow me to enter the ...
Macro security message pop up
Is there any way I can have the security message not pop up that asks t disable macros? This usually comes up if the security level is high. also have the excel cells password protected, but not sure if tha impacts the warning or not. Thanks -- sgods ----------------------------------------------------------------------- sgodse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457 View this thread: http://www.excelforum.com/showthread.php?threadid=27253 Hi if you set the security level to 'Low' you won't get these warning message. BUT I wouldn'...
Recorded macros not working using the shortcut keys
Hello, I have recorded two macros that work fine except they do not run using the shortcut keys I defined. I've stepped through the macros and the shortcut keys are in the scripts, but I can only run them by pulling up the list of macros and selecting the macro and clicking run. I'm using Office 2007 in XP. TIA, Robert When you pull up the list of Macros and select your macro, go to the options box and create a shortcut key. On Fri, 13 Feb 2009 06:11:40 -0800 (PST), CurlyDave <davesexcel@gmail.com> wrote: >When you pull up the list of Macros and select your macro, go to...
Macros and deleting a column
I've got a "contents" sheet which has numerous buttons which take users to a cell on a separate worksheet. I'd like to delete some of the columns in the worksheet as they are no longer needed. When I do this however the macro doesn't amend to the new cell reference. There's a lot of coulmns to delete and a lot of macros that won't work. Any ideas gratefully received. Hi you may post the relevant part of your macro -- Regards Frank Kabel Frankfurt, Germany "Blackcat" <Blackcat@discussions.microsoft.com> schrieb im Newsbeitrag news:F757F808...
copy paste Macro
I was wondering if it is possible to make a macro do the following. copy selected cell, move to another cell (same row) and copy change worksheets seach a column for the first copied value moe 4 cells from the cell it had found in the search then paste the second value Is it possible?? --- Message posted from http://www.ExcelForum.com/ Olark, Yes. Put this in a regular module: (paste it from here, but watch for line feeds). Dim Data1, Data2 Sub Copy1() Data1 = Selection.Value Application.StatusBar = "Data1: " & Data1 End Sub Sub Copy2() Data2 = Selection.Value Applicat...
how to record macro to roll over monthly data
hi , I need to create /record a macro to roll over a monthly data ,each month the 3 month ago figures must be added to the YTD.The remining data must be then moved one month ahead allowing space to include the new figures Thanks Anna Your description gives no idea of the overall structure and you are unlikely to get an answer better than Tools>Macro>Record new macro an record yourself taking the steps, but this is rarely repeatable each month as data is in different cells, etc. It sound like you may need an application written, but without stating yourself and trying to compl...
Protecting macros
I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received when you protect the sheet, ensure edit objects is not selected "Alec Mclintock" <Alec Mclintock@discussions.microsoft.com> wrote in message news:9D22B5E4-21A2-4477-9762-645C0A2DD504@microsoft.com... > I have a protected sheet with buttons assigned to macros. Howver the > buttons > are not protected and can be reassigned by a user using the R mouse menu. ...
Fill in fields with parameters values from macro?!
Hello, I have three letters that I need to send out on a regular basis. I want to have an Office application (Excel) call the word document and fill in the Company name and address. I need to have a Word VBA macro that can receive parameters and then substitute them in a document. I know Excel VBA very well, but not sure how to do this in Word. Question ====== How do you write a Word VBA Macro that can receive parameters and then subtitute fields in a document with the parameter values? For example: (Word VBA) Sub ChangeAddress(byRef CompanyName as string, Address...
excel 4.0 macro remover tool
Dear all, i am looking for excel 4.0 macro removal tool from excel 97 file.Actually we are facing such problem from two months and it gives pain.some excel files contain macro of excel 4.0 with "very hidden and very protective" attribute so that we cannot remove it.i have searched on net and found that there are some tools called macro remover which can remove all types of macros from excel file including excel 4.0 macro from excel 97 file,but it charges which i cannot afford.so if there any tool that can remove particular excel 4.0 macro from excel 97 file please let me know...