my right mouse-clicker doesn't work in excel anymore. something with macros happened I guess.
has anybody an idea to activate it again?? it's just in the workfield, to change worksheets-colours and stuff at the worksheet-registry it works as usual.
it's very nasty to work in cells without mouse..
I have a large project that I've been able to move all code from the workbook to an Add-In (except code that's sheet related).
I have one module that refuses to run from the Add-In. In this code
I use Excel XP 2002. I now can't copy /paste by using the right mouse button. It works perfectly in other MS products, on the net and on the desktop. l have checked my Tools/Options with other users, I have uninstalled, rebooted and reinstalled the complete Excel package but the problem persists, even from start with a blank worksheet. I have also checked and there are no add-on ticked.
View 5 Replies View RelatedI'm trying to design a form, for various staff members to populate.
I would like to ease their usage by putting a check mark in which ever cell they left click, also if they click a second time in the same cell it will undo the action.
I have not decided yet which which cells I am using, but is their some simple routine that could be used over & over again and all I would need to do would (hopefully) simply be to change the cell numbers in the routine to apply to that cell or range of cells.
I have a log that stores a list of different files in the first column. All of these files are worksheet hyperlinks (ie: =HYPERLINK("\USSS000010_PUBLIC5_COMMON15_PPA20066-032G6-032G.xls","06-032G")). If I click on any of these cells the file will open.
I am trying to open certain files from the list using VBA.
My question is Is there any way to simulate a mouse click, on the cell containing the hyperlink, using VBA?
If we mouse click any cell (right/left) it put √ symbol in that cell... How can I do it?
View 2 Replies View RelatedIn excel when you have filters on for all columns there is a little bitty square box with a little down arrow (like an upside down triangle) in the lower right corner of every cell in the top row (the header row) and I can't find a way to select one of those little itty bitty down arrows without using a mouse - -
Is there any way to select one of those little down arrows in the little filter box icon thingy with the keyboard?? I can't figure it out.
I just want to select the little arrow so that the filter dialog box opens - I am trying to create a keyboard macro that will use the 'BEGINS WITH' macro but when i record the macro it uses the same word for the "BEGINS WITH" parameter every time and I want it to use the word in the current clipboard - can't seem to write that.
For instance if I want to cut a row and column, how do I insert with the keyboard without pasting over other data
View 9 Replies View RelatedI ask because I would like to change the value of a cell within A:A to TODAY() if the user right clicks on it - or with some keyboard combination.
View 9 Replies View RelatedI want to select a function from a right mouse click that will place the current date in the selected cell.
Example:
1) Click on a cell
2) Perform a right mouse click
3) select the date function
4) the current date appears in selected cell
could this be set up so that the date function in the right mouse click only appears when specified cells are selected? Is this doable?
I have a list box with items. When I stay on item and press mouse right click, I want see pop up menu with "remove this item" and "add new item".
View 8 Replies View Relatedway, using VBA code, to disable/enable individual shortcut menu items that are are made available with a right mouse button click. The following code disables the right mouse button completely but I would like to disable only a couple of options like the ' Cut' option.
The code to disable is below and to re-enable I just change False to True.
Dim cb As CommandBar
i = 0
For Each cb In CommandBars
If cb.Type = msoBarTypePopup Then cb.Enabled = False
Next cb
I have a worksheet that I use to monitor the progress of student interns. They are assigned 20 different tasks and recieve 5 points for each task they complete, for a possible total of 100. In my worksheet, I record their progress and maintain a running total. I do this by simply inserting the number "5" by each cell containing each task. Instead of inserting the value, what I'd prefer to do is simply place my cursor, click the mouse button, and have a formattable check mark appear with a hidden value of "5". I'm simply trying to create a snazzy interface. Do I want too much? Or is it actually possible to do this?
View 14 Replies View RelatedI have an excel file with a column (I) which lists the total number of businesses in a different tab (DATA) that meet certain restrictions (these restrictions being listed in the same row in different cells). When the cell under coluimn "I" is double-clicked, it pulls the businesses from tab DATA that meet the restrictions for that row and shows them all in another tab.
I don't know the person that created this and was wondering if there is a way to figure out what is being done to make this happen? I looked in macros, but didn't see anything relating to this. Anyone know how this is done?
So you know, I have tried double-clicking other cells, but nothing happens - not even editing into the cell (altho this can be done from the toolbar up top).
I have a menu structure in place so when a user clicks a button, it opens a Userform as a menu. The only problem i have is that if the user doesnt want to use that menu, and clicks on the spreadsheet, it doesnt dissapear.
Is there any VBA code that anyone knows that when a user clicks on the spreadsheet, or even just clicks their mouse anywhere (ie other menus at the top, spreadsheet, desktop) like a mouseout code on HTML so the menu will dissapear?
A list box selection works fine on my computer but on a friends Windows Vista PC the following happens:
Selecting items near the top of the list works fine. 1/4 of way down a mouse click on an item selects the Next item.
1/2 of the way down in the list, the mouse click on an item selects the one 2 or 3 further down, etc., etc.
it would be possible to have text disappear after being displayed in Excel for a while.
My son and I played around with games (helping create a photographic memory, I told the youngster!) on the thing and until yesterday neither of us noticed that clicking the mouse anywhere (actually just clicking it) causes the screen to "freeze" while the code still happily erases the text in the background.
Hitting ESC allows the screen to cath up to the actual code EVEN THOUGH the ESC key is actually disabled from breaking the code.
I'm using code based on the following post: Add Borders To Cells Of Spreadsheet From Access. That code was developed for a relatively small recordest. I am using the same coding style to transfer a recordset that has roughly 2000 records in it. Since this is all taking place over a network there is a period of time (about 15-20 seconds) where Excel is open and the user is watching the cells get populated from Access. If, during that period of time when Excel is open, the user clicks in a cell during the population of data, it stops the process and causes an error on the Access end (Error 50290: Application-defined or object-defined error). Is there a way I can prevent user input (perhaps prevent signals from the keyboard and mouse) until after the data has been transferred? I know this is a long way to do a TransferSpreadsheet command but I like the way the column headers get formatted as well as the column sizes. I also think it's pretty cool to watch the data populate as it goes.
View 2 Replies View RelatedI've just inherited a load of Excel files I need to continue using, but my predecessor has done something that disables the middle-click scroll ability.
I can still scroll up and down by turning the wheel, but I want to be able to click it and scroll in all directions at speed - I didn't realise how much I used this until I couldn't. Can't see anything in the VBA sheet properties, and they are all .xlsx files. Nothing leaps out of the settings either. If I create a new file or a file of mine within the same session, they work fine.
Locking text in cells but not the ability to change colour of cells
******** width="234" height="60" frameborder="0" marginwidth="0"
marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" id="aswift_0" name="aswift_0" style="left: 0px; position: absolute; top: 0px;">*********>
I have a spreadsheet where I can change the colour of a cell by clicking the mouse, I also have text in many of the cells.
What I need to do is protect (lock) the text so that no one can change the text in any of the cells, but I still want to be able to change the colour of the cells by clicking the mouse in that cell.
I am trying to take two random Mouse click selections and swap a set of ranges associated with the cells that are selected. For example if the user clicks on A1 it will resize(3,22) and store the selection as a variable to be swapped with another selection. Here is what I have so far but I keep getting a object required error on rngEmp1.
VB:
Sub SwapGroup()
If Selection.Cells.Count < 8 Then
MsgBox "Please Select two Groups to swap. Press and hold 'Ctrl' in between your selections", , "Swap Groups"
[Code] .....
I currently have a set of ListBox controls on a worksheet tab. They are all configured as multi-select and i have the values populated via the ListFillRange properties. Each listbox has an '{All}' option; when the user clicks on this value I want to de-select all other previously selected values. The code for this is straightforward enough, but I cannot get it to fire using the _Click event. Why this is not working?
Additionally, I attempted to use the _Change event but quickly got caught in recursive loops which obviously is not going to cut it.
I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?
View 11 Replies View RelatedBy chance I have opened a sheet with some macro and after that 'right click' is not working in any of the excel sheets (even newly created ones) in sheet names tab.
i.e., I can't delete/rename/insert etc in any sheet by rightclicking the sheet name.
Even the Edit->'delete sheet' is disabled. However, Insert->worksheet is enabled.
How to make the right click enabled. (excel version 2003)
Normally when I double click on a cell with a formula linked to another spreadsheet, the double click takes you to the source. However, if the cell also has a comment, the double click takes you into the edit comment option and not to the source.
Is it possible to turn off the edit comment option from the double click?
When I copy or cut, I usually get a dashed border around the cells I have copied (or cut), I can then right-click somewhere to paste, but at some point in time recently this functionality has stopped working. The format painter doesn't work either - the paintbrush icon stays pressed for about half a second, then just goes away and I can't paste my formatting.
An operation I often do in excel is to copy a date from one cell, then highlight a few cells elsewhere and press enter to paste the date into them. I also like to right click on a row and Cut, then past it further down my list to re-order things, but this won't work either.
I don't know what I've done to make it go away. If I restart my computer and open a workbook, then I can copy/paste at least once (maybe a few times) then it stops again.
This is caused by a Skype 'click to call' function, but I don't have that installed here. I have actually just tried installing it, so I could run through the uninstall (thinking there might be debris from something previously), but it made no difference.
is there a way to launch a macro when your mouse is over a specific cell or a specific range of cells ? The idea behind is to update a chart based on the cell value, in case a name, with its associated values
Is it possible to display a name on a chart that is not the X or Y value?
I've been sent this macro which displays the school name on a chart when the mouse is on the data point - its all well and good but on the graph I am working on, the X and Y value are both values and I want the school name to come up as well.
Private Sub Chart_MouseMove(ByVal Button As Long, ByVal Shift As Long, ByVal x As Long, ByVal y As Long)
'macro that gets chart to show user details of a point on the chart when the mouse is moved over it
Dim ElementID As Long, Arg1 As Long, Arg2 As Long
Dim myX, myY As Variant
With ActiveChart
.GetChartElement x, y, ElementID, Arg1, Arg2
If ElementID = xlSeries Then 'checks to see which part of the chart the mouse is over
On my worksheet, i want to execute a macro to calculate and display some informations when the mouse is positioned over certains cells. I look around but did not found how to do it.
I want the information to be displayed above that cell and disapeared when mouse pointer moved away.
i have a Macro Button which overlaps the cell G2 (a merged cell)...
is it possible that "when Press Enter Key on cell G2 then Launh a Macro.
or
when press space bar on cell G2 then Launch macro"... Macro is same as the Macro Button that overlaps G2...
this would prove to be a faster way than using a mouse to click on a macro button.