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)
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, "firstname.lastname@example.org"
>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
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
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.
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;
City, State, Zip:
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
City, State, Zip:
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..
"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.
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?
<email@example.com> wrote in message
> 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
"DNA" <firstname.lastname@example.org> wrote in message
> 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?
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
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
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly fr...enter data in cell then run macro automatically
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?
That type of macro is run from Event code.
For more on events see Chip Pearson's site at
Or David McRitchie's site at
Gord Dibben Excel MVP
On Tue, 25 Jan 2005 21:04:42 -0000, "R D S" <RDS@members.v21.co.uk> wrote:
>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
you are coping the conditional format t...Macro help #10
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
No one's been able to help me out from my previous posts, so I'm still
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
If Selection.Interior.ColorInde...Macro help?
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
Granite Shoals, TX
"Ken" <email@example.com> wrote in message
> 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
sgodse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457
View this thread: http://www.excelforum.com/showthread.php?threadid=27253
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
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.
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
>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
There's a lot of coulmns to delete and a lot of macros that won't work.
Any ideas gratefully received.
you may post the relevant part of your macro
"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
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/
Yes. Put this in a regular module: (paste it from here, but watch for line
Dim Data1, Data2
Data1 = Selection.Value
Application.StatusBar = "Data1: " & Data1
Data2 = Selection.Value
Applicat...how to record macro to roll over monthly data
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
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
> I have a protected sheet with buttons assigned to macros. Howver the
> are not protected and can be reassigned by a user using the R mouse menu.
...Fill in fields with parameters values from macro?!
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.
How do you write a Word VBA Macro that can receive parameters and then
subtitute fields in a document with the parameter values?
Sub ChangeAddress(byRef CompanyName as string, Address...excel 4.0 macro remover tool
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...