I have a ridiculous amount of buttons that initiate macros on my worksheets. Is there a drop down menu option to consolidate or group certain buttons to make more room and less button clutter?
Secondly, if I put my macro buttons on the toolbar, will that diminish the amount of time it takes to save my workbooks? Currently an 800 kb file takes almost 10 seconds to save. Your help is greatly appreciated.
You can create a new menu item and assign your macros to different items in
that menu or create submenus to group your macros by type.
Right click on a toolbar and select Customize. U...Autofill until
Hi all! Does anybody know a simple macro code for autofilling cells in a
column until a certain cell is reached. Ie. I'd like to autofill from
cell F2 all the way to cell F50 only. Any help on this would be great.
uberathlete's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28388
View this thread: http://www.excelforum.com/showthread.php?threadid=483585
Did you know: you can build such a macro yourself by recording it.
I am currently training employees to use Excel more efficiently and as
part of the course, I explain the uses of AutoFill.
I warn them to verify that any patterns or series that it AutoFills are
what they expected, and not some other pattern.
As an example of where it can go wrong, I type 1,2,4,8 into four
adjacent cells (hoping to get 16,32,64...) and use AutoFill to continue
What it actually gives is 9.5, 11.8, 14.1... or different, depending on
where I start the series and how many intial cells I use.
I'd like to tell them what pattern it is ACTUALLY continuing, but I
can&...How to rename the Excel button on the desktop?
I'm now running on XP professional. The Excel button on the desktop shows
the Excel symbol followed by Microsoft Excel - filename. shorten this to
just "filename" so that one can actually read the filename. In Windows 98
this was not a problem.
Further info: I now see that the file name is more readable as more buttons
accumulate in the desktop taskbar (bottom of window). The "Microsoft Excel"
away then. Still this is initial naming is annoying ... but I can live with
> I'm now running on XP professional. The Ex...Adding 'Dial-Phone' Button
I have a client that wants to add a Dial Phone button to
the contacts screen. I have several questions. Can this
be done? Can this be done with the current demo version?
Where would I even begin to add something like this?
You need to start reading the CRM sdk to understand how to add or modify any
For example, you could add a button to the CRM contact form which when
clicked calls the phone number of the contact.
search on msdn.microsoft.com for Microsoft CRM
"BJF" <firstname.lastname@example.org> wrote in message
news:0f2501c3a9f9$5b6ae9b0$a301280a@p...Menu in Word behaving oddly; items (like the entire contents of the Tools menu) disappearing...
Hey, I'd be oh-so-grateful if anyone has any idea how I could address
this problem. I'm quite mystified. I'm running MS Word for X on my Mac
(OS 10.4.3), and lately some odd things have begun happening. At first
I was just working around them, but I've decided live my computer life
too much that way (ignoring problems and hoping they go away), so
thought I should look into this before it gets out of control. Items
have been disappearing from the Word menu bar. That is, for instance,
after I had used the "Symbols" option under the "Insert" menu one day,
it di...Autofill Options
I am developing a database to track training for employees. I would like to
be able to type in a first and/or last name and/or an employee number and
auto fill what I don't enter. My managers will be using this database and in
order for it to be accurate and complete I need first/last name and employee
number. I can't figure out how to get an autofill option to work.
It isn't clear where you want this to happen...
If you are using MS Access, the appropriate place would be in a form (rather
than directly in a table).
In a form, there really wouldn't ...Create a button to find the next record
I am trying to create a button to find the next record for a particular
There is a main form and subform. I want to be able to find all relevent
subforms for a particular student. The master link id is STUDENTID and the
child link id is STUDENTID_FK.
So for student #1, when I click on the subform and click on the button, it
would cycle through all this student's records.
What is the best way to set up this button?
Thank you for your help in advance.
You already have one that is built in. Just click the navigation button
right of the record number ...How do I keep a button size the same!
I am running several macros that import information from
another program via "command buttons". The information is
importing in to a pivot table that changes in width based
on the "garment size available" column. When I execute
the macros my buttons are changing sizes! Can I control
Thanks in advance.
1) Select a button causing a problem (or select them all at once)
2) Right click and select "Format Control"
3) Select the "Properties" tab and select "Don't move or size with cells"
4) Repeat 1) to 3) above for each but...hyperlink in button
I have a problem with a hyperlink that I added to a button in Excel
It is a link that opens an excel file on my harddisk.
The first time excel opens the file.
When I close the document and click on the link again, the file is not
The first time that I click on the link , the workbook book1.xls is
The file book1.xls closes when I close the file that I opened with the
hyperlink. So the second time that I click on the hyperlink, the file
book1.xls is not active and the desired file does not open.
I have windows XP on my pc. I also tried this on a pc with wind...Outline format disappeared
I am no longer getting the hierarchical tree structure of messages on this
forum. They are all listed one after another in date order. Can anyone
suggest how to get it back?
"Nicholas Geti" <email@example.com> wrote in message
>I am no longer getting the hierarchical tree structure of messages on this
>forum. They are all listed one after another in date order. Can anyone
>suggest how to get it back?
It would have made things a lot easier if you had told us how you're
accessing this newsgroup...Navigation buttons
I am having a problem creating button for navigation on a
Web page in Publisher. I can create the fist button no
problem but when I try to create a secon either by copying
or inserting a new object, there are both linked together
and I can not change them. Can anyone help me solve this
In the future please refer to the webdesign forum at
The nav bar wizard has some minor differences across versions, and you
failed to state your version, but this article -
http://www.publishermvps.com/Default.aspx?tabid=90 - will give you a b...change text and icon of a XP grouped taskbar button
I need to change the text and icon of the taskbar button that XP collects
simular buttons under, (after choosing "Group simular taskbar buttons" in
the taskbar properties)
Can anyone give me directions on where to start looking?
thanks and regards
...contents in word doc disappeared
typing in word doc and suddenly everything disappeared. Had done several
saves but when I try to pull up doc it is empty. Did I hit something that is
hiding doc from me/
Saving the document was your mistake. Your first reaction should always be
Ctrl+Z (Undo). Mostly likely you inadvertently pressed Ctrl+A (Select All)
and then pressed a key that overwrote your entire document. Now that it has
been saved (especially more than once, which also overwrote your backup, if
any), you're out of luck.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabam...Autofill Formulae
Hoping someone can help me to solve my dilemma.
My spreadsheet has two worksheets. One worksheet has a list of numeric
values running vertically, and I am trying to transplant them onto the master
worksheet running horizontally.
eg on the secondary worksheet A1=5, A2=6, A3=8 etc
on the master sheet, A1 ='secondaryworksheet'A1 and B1
The problem comes when I try to autofill across on the master spreadsheet.
Excel does not seem to recognise the sequence (I think it may be because of
the horizontal/vertical factor). I have tried to use absolute ...Command Button #2
How do I create a command button in a worksheet and assign a command t
it using the control box tools, e.g., to sort a list of figures in
vijay22's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3411
View this thread: http://www.excelforum.com/showthread.php?threadid=53885
The macro recorder is your friend. Just use tools>macros>record when you do
your sort manually. Then, assign to a button or a shape. I do not recommend
Don...No filter buttons
I'm using Excel 2000. Recent problem. When I try to
apply a filter to any table of data, the table header
doesn't show the arrow buttons as part of each header
cell. There is no error message and when I go back to the
Data-Filter menu, the option is selected as normal.
Probably something simple but I can't find it. I've
rebooted and made simple tables to troubleshoot the
problem, but so far nothing.
Sometimes those pesky arrows will reappear if you minimize excel's window, then
Sometimes if you minimize the worksheet'...Option Button to Restrict Qry
On my from I have an option button that limits the list in a combox to Active
employees. When it is not checked I would like the qry to return all records.
It works fine for when the option is true but not for when false (right now
it returns none). Can you see where I went wrong in the SQL? Also does anyone
know a way to refresh the data in the combobox without having to close and
relauch the form after the optioin button has been updated? Thank you
SELECT Tbl_EmployeeMaster.QI, Tbl_EmployeeMaster!LNAME & ", " &
Tbl_EmployeeMaster!FNAME AS FullName
FROM Tbl_EmployeeM...Border Art Button Missing in Dialog Box
I have 200 high school students working in Publisher 2003 on Windows XP SP3.
SP3 was installed a few days ago. However, I don't know if this problem
existed before then. We are on a Novell Network, but the program was
installed locally from an image distribution.
On some of our computers, the Border Art button is missing in the Format
AutoShape and Format Text Box Dialog Boxes.
The button was originally there. I have no clue how students removed the
Can someone help me put the button back so that border art is available again?
Can you tell me how the button was removed?
...Send/Receive Button Missing
I han an Exchange account that wasn't working so I deleted it. Then I
setup a POP3 account to download my e-mail. But there is no send and
receive button. I tried repairing Outlook and re-installing Outlook, but
it's still gone. Any ideas? I'm using Outlook 2003.
Mike Lambert <firstname.lastname@example.org> wrote:
> I han an Exchange account that wasn't working so I deleted it. Then I
> setup a POP3 account to download my e-mail. But there is no
> send and receive button. I tried repairing Outlook and re-installing
> Outlook, but it&...Autofill
I'm having a problem with autofill. I can drag and drop but when I want to
see the options, before I can mouse over to the options box, the box vanishes
as soon I've moved off the initial cell that was copied. I'm not fast enough
to get to the options, so it would be good if someone could tell me how to
keep the options box available.
The Auto Fill Option button is displayed after you select the AutoFill option
in the Series dialog box. To show the Series dialog box, use one of the
In Microsoft Office Excel 2007, click the Home tab, and then cl...Create a button with a macro vba
I'm trying to create a button with a macro vba.
I have a button that show a form in a sheet, when the user fill the
form and click submit the macro receives data from AS400 and create
some sheets, one every agent. I'd like to have a button in every sheet
for call the inizial form!
Have somebody a sample or a link where I can see?
...Autofill by increment
I am trying to do something which seems easy and intuitive but I can't get it to work. I would like to create a table of data from existing data on the worksheet and create a chart. I am trying to use Autofill and have the data automatically populated. I need every 20th row from the existing data.
Existing Location Data is in b9, b29, b49, etc. I would like this data to be pop'd in ar3, ar4, ar5 et
Existing acct data is in d5, d25, d45, etc. I would like this data to be pop'd in as3, as4, as5 et
(The existing data is in a form layout, so that's why...Toolbar & OnUpdateCmdUI
I have an application with a toolbar and I'm using OnUpdateCmdUI to
update Toolbar-Button states.
The Toolbar is derived from CToolbar and has just a few additions.
This is not my work, though.
The Toolbar has 9 Elements, them being 7 Buttons, a checkbox (is
logically a button, too) and a dropdown combo.
The checkbox and dropdown are added dynamically during runtime
(replacing an existing resource), but all the buttons are from the
Two of the buttons in the resource were just added the other day.
Now when I come to update my button-states I found out that so...Next/Previous items buttons
Can you add buttons which will allow users to move to the next or previous
item in a list or view so they don't have to always save and close, just
save, press the next button and carry on without having to figure out which
item is next (sometimes the current item in a list/search does not stay
hilighted and if you have to look through several to find the one you last
worked on, that's a pain.).
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I