Redo / Undo Buttons Are Greyed Out

Aug 9, 2013

In some excel files the redo / undo buttons are grayed out

View 3 Replies


ADVERTISEMENT

Unable To Undo / Redo

Apr 16, 2007

I am unable to undo/redo in MsExcel. Have tried to uninstall/reinstall office, all updated are current.

View 9 Replies View Related

Why Do Some Excel Documents NOT Allow To Undo / Redo When Using Macro

Jul 11, 2013

Some of my Excel files work perfectly in terms of undo/redo, while others simply cannot use that feature. I took a stroll through the internet looking for the answer, but the issues that I found seemed to point to the application losing its ability, which was resolved with a registry edit/update/change. I don't think that's the case here because I CAN undo is SOME documents.

After some investigation with my problem documents I have found that THIS Macro is the one thing all my undo-free documents have in common: [URL]

View 14 Replies View Related

Excel 2007 :: Redo And Undo Broken After Save?

Jun 8, 2010

I have Excel 2007.

Undo / Redo - they do NOT work properly after a save. Before a save, its great - I can undo / redo many many changes.

After a save, I can only undo 2 changes, but the worst thing is it ONLY REDOES ONE of them.

I work by saving very regularly, then I go and look at something on the sheet, and then use Undo / Redo to get back to where I was last updating the sheet and see what I had just been working on, especially if its a few minutes in between.

However, when I do that now, it undoes my last change, but the redo has been lost. So I do:

change, save, undo, redo

and it just doesn't do the redo. The redo button is greyed out.

If I do:

change, change, save, undo, undo, redo, redo

the first redo works, and the second fails as the redo has been lost.

It seems pretty basic that undo / redo should be symmetrical but they aren't, at least now.

I would rather just not have undo after save at all than this broken version.

Why are they putting so much stuff in Excel but they can't even get one of the most basic parts of spreadsheets correct - such as undo / redo, and the ability to open independent spreadsheets without having to change things in the registry (which I have had to do so I can work on two spreadsheets in a semi-sane fashion, undo being shared across your sheets otherwise). MS needs a back to basics...

View 5 Replies View Related

Unod/Redo

Apr 23, 2007

Couple of the end users are unable to use undo/redo functions on certain excel worksheet. I have uninstalled/reinstalled office 2003 without success. Then I even installed office 2000 and office XP without any luck. Have checked into macro's and clipboard and also got idea of adding registry value.

View 13 Replies View Related

DTPicker: Redo The Same Thing Over And Over Again When Others Opens

Feb 21, 2007

i implement DTPicker inside a userform in my pc ... but when i open the userform in other pc there's an error saying could not found DTPicker ... when i reopen it in the pc that i've made the userform the DTPicker is no longer there and i had to redo the same thing over and over again when others opens it in other pc.

View 4 Replies View Related

Using VBA To Save And Redo Autofiltering Settings

Aug 9, 2007

I am trying to figure out how to save a worksheet's autofiltering settings and be able to re-create those settings.

I would start off with a spreadsheet with a few Autofilters on. I would like to make a macro that will record the initial Autofilter settings, then the macro would do a bunch of stuff that would need to 'Show All'. After these actions take place, I would like to be able to return to the initial Autofilter settings. I'm not even sure which VBA command should be used for this sort of thing.

View 9 Replies View Related

Greyed Out Pages

Nov 25, 2008

I opened an Excel file, and the whole page is grey. I can't see the cell lines at all. How do I get it back to white with all my gridlines?

View 3 Replies View Related

Edit Links Greyed Out?

Sep 10, 2009

I've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work?

View 6 Replies View Related

Paste Special Is Always Greyed Out

Jul 7, 2006

Paste Special is no longer available in the Edit menu--it's grayed out. (I am using Excel 2003). I can't find any info on what disabled it or how to re-enable. It's probably something moronically obvious, but this moron needs a shove in the right direction.

View 6 Replies View Related

Some Sub-Menus Disabled - Greyed Out

Nov 6, 2006

I have noticed that the submenus for the following main menu items are disabled

Edit Insert Format Data

The submenus for the other main menu items are fine.

I have not run any macros that alter the menus.

I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,

View 3 Replies View Related

Autosum In All Files Is Greyed Out

Dec 2, 2006

The Autosum in all my Excel files is greyed out. I am able to use the icon button to perform autosums but am unable to turn off "autosum" from the tool bar. I have turned the EnableAutosum to "true" in the Editor with no luck. What am I missing?

View 2 Replies View Related

Multiple Macro Buttons (radio Buttons)?

Feb 10, 2012

I am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.

Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.

While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.

Is there a quicker way?

View 6 Replies View Related

Change The Color Of Buttons Or Command Buttons

Mar 14, 2007

Is it possible to change the color of buttons or command buttons? There does not seem to be any place that allows this under properties for buttons, although there does for command bars. However, I've tried recording a macro as I change the color, but nothing get's recorded so I'm not sure what the syntax would be.

I have a spreadsheet with several buttons and I'd like them to change colors as they are pressed so it's possible to see what you've already done. And then, as soon as any other cell on the sheet is changed, the buttons reset color.

View 9 Replies View Related

How To Activate Greyed Out Ribbon Items?

Jan 2, 2009

I would like to restore some important functionality in Excel 2007 which has become disabled for a spreadsheet which I saved in different file formats.

I opened an Excel 2003 file with Excel 2007 and used 'Save As' into different formats (default, macro-enabled, binary) to see the resulting file size.

A number of Ribbon items are now greyed out for this file, including,
- Insert - Tables, Illustrations, charts, etc.
- Styles - conditional formatting and Format as table,
- Formula Auditing
- Data - just about all of them
- View - some of the Window items.
Also, I cannot resize or move a button on a worksheet.

Attempts to 'Save As' into the Excel 2003 format cause Excel 2007 to hang.

What caused so many features to become disabled?

How do I restore them?

View 6 Replies View Related

Only Few Cells Normal - Rest Greyed Out

Mar 16, 2013

I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.

Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.

What is this? And, how do I set it up in a spreadsheet if I need to?

View 2 Replies View Related

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

Audit Toolbar Items Greyed Out

Sep 22, 2006

I am using Excel 2000 on Windows 2000. There are no macros on spreadsheet and no protections at all yet I acnnot use trace precedents/dependents as the items are greyed out.

View 2 Replies View Related

Icons On Control Toolbox Greyed Out!

Aug 14, 2007

I've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below

pukks Auto Merged Post;Doh Doh and double doh!

Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.

View 2 Replies View Related

Excel 2007 :: Delete Sheet Greyed Out

Jan 13, 2009

I am using excel 2007 and when I right click on the worksheet tab, delete is greyed out. My workbook/sheet is not shared. I also had the problem owith row and columns. CommandBars("row").Reset sorted that out but I can't seem to sot out the tab issue.

View 6 Replies View Related

Hide Combobox But Move / Size Is Greyed Out

Nov 6, 2012

I've got Combo Boxes and at times I want to hide this. However, when I do, the combo boxes don't hide and are still visible. Here are my steps: Right Click on the combo box, chose Format Control, then under the properties tab, the choice to select "Move and size with cells" are greyed out.

View 4 Replies View Related

Items Greyed Out On Sheet Right Click Menu

Jul 11, 2007

I cannot figure out why this setting has changed. When I right click my tab worksheet in Excel to copy or rename, it does not allow me. I will need your advice to re-activate that options so it is visible and not gray. I tried in the VBA workbook properties settings with no luck and also Tools, Options.

View 6 Replies View Related

Excel 2010 :: Highlight Range And Right Click Greyed Out

Apr 4, 2014

I'm using Excel 2010 and when I highlight a range and right click 'name a range' is greyed out. I can bypass this by going to the formulas tab and defining a name from there.

Anything I can check to see why this is not an option for me?

View 3 Replies View Related

Macro Error In Workbook - Entire Ribbon & Icons Greyed Out

Mar 3, 2009

I ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).

View 9 Replies View Related

Undo Column Name

Apr 1, 2009

How do undo a column name, say you named column "b" boy how do you get it back to b.

View 2 Replies View Related

VBA Code For Undo

Nov 26, 2009

A Worksheet_Change macro in Sheet1 changes the font colour if the target is cell(1,1). So, if I change the value of cell(1,1), it will become red. But then I cannot change it back to the original value because the undo button is not active anymore. And what if I changed cell(1,1) by mistake instead of cell(2,1), and I want to put it back to the original value?

View 5 Replies View Related

Undo Action In VBA

Jul 18, 2006

I have a database in excel which I want only selected users to have edit rights & others should have readonly rights. I have written the following code where a pop up would appear in selected cells warning user for editing the said cell. What I want is when a user clicks yes he should be able to edit it & when he clicks no the cell should get protected.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Dim rTriggerCell As Range
If Not Intersect(Target, Range("D1:D100")) Is Nothing Then
Set rTriggerCell = Target
Application.EnableEvents = True
If MsgBox("Edit Cell?", vbYesNo)
End If
On Error Goto 0
Exit Sub
End If

View 6 Replies View Related

Data Table Is Pasted In For VLookUp - Not Have To Redo Table Name Each Time

Jun 2, 2013

I created a lookup table that works quite well. It even has if statements in the LookUp Formula. However, I have to update the table it pulls the information from each day. I wind up recreating the range each time because the table always has more rows each time. Is there a way I could just paste the table in each day and not have to change the range? The columns never change.

View 9 Replies View Related

Greyed-out Columns Based On Cell From Specific Column In Active Row Being Edited

Jul 7, 2014

I am making a spreadsheet in which I have been asked to have certain column greyed-out based on an answer that was given in a dropdown menu. Specifically, a dropdown menu in column D asks if the client was a Youth or an Adult. Depending on what the anwer is, other columns in the spreadsheet will be greyed-out; different ones for each answer. My problem is, I need this to occur for the active row being editted. For example: The first row that the user can input data into is row 4. If D4 is answered with "Adult" then certain other columns are greyed-out. However, if the next time the user updates the spreadsheet with information for a different client (now entering information in row 5) and they select "Youth" for column D5, then different columns get greyed-out. The columns that are greyed-out will depend upon the answer for the dropdown menu in column D for whatever row is actively being editted.

View 5 Replies View Related

Undo Text To Columns?

Jul 20, 2009

How do I undo text to columns?

I had a list of email addresses that I put into two columns with the @-now I have finished manipulating and I need to have the email addresses whole again.

The email is now in column A and the domain is in column B. I cannot click undo.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved