Run Code When Clicking Locked Cell

Nov 1, 2006

I have programmed a Form in VBA that initializes by clicking a button on a worksheet. The Form features combo boxes, text fields, and a couple option buttons. Once completed, the Form enters the values entered by the user (as strings) in contiguous colums in a single row. The worksheet is locked so as to not allow users to input values into the worksheet directly and bypass the Form.

The question:
Once a row is filled by submitting the Form, i want to allow a click event on that cell (like double-clicking, for example) to pop-up the Form, but containing the corresponding values from the cells in the matching combo boxes, text fields, option buttons. I want to do this so that I can allow modification on a row without letting the worksheet be modifyable without passing through the Form. Here's the code for submitting the Form values into the worksheet:

Private Sub cmdSubmit_Click()
ActiveWorkbook.Sheets("ALTEC Growth Report").Activate
Range("A7").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = Trim$(txtName.Value)
ActiveCell.Offset(0, 1) = cboCC.Value
ActiveCell.Offset(0, 2) = cboProdServ.Value
ActiveCell.Offset(0, 3) = cboStatus.Value ..................

View 8 Replies


ADVERTISEMENT

Prevent To Take Me To Another Sheet When Clicking On A Locked Cell.

Jul 11, 2009

I have one issue with my protected worksheet. Some locked cell contents are linked to cell contents located in another sheet. When I double clicked on these cells, a warning window poped up but also opened the sheet in which the corresponding cell is located. This is quite annoying to have to go back to the former sheet. How can I prevent it ?

View 3 Replies View Related

Clicking Locked Cell Activates Hyperlink

May 29, 2007

I have created a workbook of 12 monthly worksheets, with an index page with hyperlinks to each worksheet. There is also a hyperlink on each worksheet to return to index page. Each worksheet is protected, but the cells which users can enter information are not locked. The protected worksheets have the 'select locked cells' unticked.

I have found that an inadvertant click on any of the protected cells in the worksheet will take users back to the index page. This is very annoying, what have I done wrong? The hyperlink is one of the unlocked cells.

View 6 Replies View Related

Excel 2010 :: VBA - Run Code Only When Clicking In Specific Cell?

Dec 23, 2013

how to run some VBA code (written by someone else, unfortunately) only when clicking once in cell A1, and not run in any other cell. This is being run in Excel 2010. The code I would like to run in this manner is below, and currently will run when the user clicks on any cell in the worksheet it is applied.

[
Option Explicit_________________________________________
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'If IsDate(Target.Cells(1, 1).Value) Then
Set DatePickerForm.Target = Target.Cells(1, 1)
DatePickerForm.Show vbModal
Cancel = True
'End If
End Sub
]

View 3 Replies View Related

Repeating The Code: Jumps By Clicking On A Different Cells

Jul 23, 2009

I run this code in my workbook and it seems to work but i would like to do same kind of jumps by clicking on a different cells and cant seen to figure out how i can add more of these function.

View 2 Replies View Related

Excel 2007 :: Clicking On Cell Auto-selects Cell Next To It - Cannot Disable

Nov 16, 2010

Whenever she clicks on a cell, the cell to the right of it is also selected. When she tries using tab to move to a new cell, she can only move between the two selected cells. Same with using the enter key. As such, it is extremely difficult for her to modify only one cell, since she always has two selected.

The F8 key, as well as Ctrl+F8. However, pressing the F8 key only adds more cells to the autoselection, and Ctrl+F8 allows her to select one cell, but also highlights the cells around it, and when we tried to select other cells, every cell we clicked stayed highlighted.

Additionally, sometimes when she clicks a cell, it will just select that one cell. Click it again, and the problem is back. I haven't been able to determine any patterns to this behavior, and I know there is no problem with the input (the keyboard and mouse are standard-issue in our lab, and we keep them well maintained).

View 8 Replies View Related

Excel 2010 :: Changing Cell Color And Border By Clicking A Cell

Apr 25, 2014

I would like to accomplish 2 things in my Excel 2010 spreadsheet by click a cell which already has a number and formatting in it.

1. How do I change the color of the cell, the color of the number in it, and the border around it. (Make it look like I just pressed a button by clicking it.)

2. At the same time have the text in different cell and the number in the selected cell appear in another different cell. (Text in a different cell = A , and the number in the selected cell = 23, the value in the resulting cell be "A 23") Everything I would like to happen at the same time by clicking the selected cell. I would also like this to be done several times by clicking different cells and not changing the previously selected cells.

View 1 Replies View Related

Run A Macro By Clicking A Cell

Nov 6, 2008

I would like to run a macro by clicking a cell. I don't want a toolbar button/menu item and Hyperlinks don't work. Can this be done?

More info: My macro selects the current row in Sheet A and moves it (cut & Paste) to Sheet B in the workbook. The macro then goes back to Sheet A and deletes the now blank row.

View 6 Replies View Related

Changing Cell Data By Just Clicking On It.

Apr 6, 2007

i have made (found) a way to change the data in a cell by clicking on it, however i can only make it go from 1 to 0 or 0 to 1...heres the VB
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If (ActiveCell.Value = 1) Then
ActiveCell.Value = ""
Else:
If (ActiveCell.Value = "") Then
ActiveCell.Value = 1
End If
End If
End Sub

however, i would like the code to do a different task, i would like it to add one to the number everytime you click on it...i.e. it goes from 1 to 2 to 3 to 4 to 5 etc. everytime you click on it...

if it is possible, i would also like it to be restricted to a few cells, which i can determine afterwards and change

View 14 Replies View Related

Clicking On A Cell To Get Additional Details

Feb 3, 2009

I have seen this on many spreadsheet but never figured out how to do this - click on a cell in a spreadsheet to open up a new spreadsheet?

View 4 Replies View Related

Change Color Of A Cell By Just Clicking On It?

Aug 25, 2009

I'm trying to do. I have 2 columns, both have empty cells with borders. I would like to make it so that when the user clicks one of the cells, it turns grey and the one beside it turns white. I set up two macros as follows:

View 3 Replies View Related

Start Macro From Clicking In Cell

Oct 30, 2007

I have created a macro that autofilter values in sheet 2.

In sheet1 I have a cocpit of values from Sheet 2, 3, 4 and 5.

In the monitoring cells in Sheet1 I would like to doubleclick (or similar) in the cell where I have a value from ex sheet 2, and then trigger the macro which does the autofiltering.

View 9 Replies View Related

How To Get A Userform By Double Clicking A Cell

Jul 26, 2008

how to get a userform by double clicking a cell.

I have created a userform, (my first one)-very simple form, i have created a massive textbox, so when i doubleclick a cell in Sheet 1, userform pops up and I can write comments.

I am not sure how to write a code for this? I know it will have Private Sub Doubleclick, not sure on the rest?

View 9 Replies View Related

Run Macro When Clicking On A Specific Cell

Aug 15, 2006

I am trying without success to for a macro to run when a specific cell is activated. i.e. if a users selects cell A1, macro X will run.

View 2 Replies View Related

Display Message By Clicking Cell

Dec 12, 2007

I want to display a comment/note that is always visible however:

*The text in the comment should change "only when" the user of my worksheet "clicks" on a specific cell in the worksheet;
*I do not want that a comment appears/disappears/ changes when the mouse moves over any of the cells
*I do want that the same comment/note is used to display different text when the user clicks on another cell in the worksheet
*I do want that the user can position this comment on his screen where he wants it to be.

View 2 Replies View Related

Line Connecting A Cell To A Table....and Locked On The Cell

Jan 21, 2010

I have multiple data tables in one sheet...and each one has a chart...in that sheet. To better allow the viewer to coordinate quickly which data table corresponds to which cart...i want a line between them. Excel already has the draw line function, but if you move the chart around, the line doesn't move.

View 2 Replies View Related

How To Copy A Locked Cell Without Formula

May 13, 2013

I have created a spreadsheet that will be viewed/used by various users (read only as I have protected the sheet except from three fields), although I would like to give them the ability to copy the contents of a specific cell that is protected.

I have tried to give them the ability to select the locked cells and then copy, but that means that the formulae in the cell is copied as well.

how I can let people copy a locked cell without the formulae?

View 2 Replies View Related

Entering Text In A Locked Cell

May 29, 2014

I have worksheet that contain values in column E and G and the total in column K. E and G are unlocked for manual input and column K contains the formula for the total and is locked. From time to time a certain row will not be applicable and before I started locking the cells in column K i would just put "not applicable". Now that it's lock I can't do that. My only option now is to put O in column E and G but I would rather put "not applicable" in column K. Is there a way around this. I was thinking of something along the line of a macro that would unlock the worksheet input the text and re lock it. The macro would have to lunch when a locked cell is selected or have a button that would launch the macro an would prompt for which cell the text would be entered. Is this possible.

View 7 Replies View Related

CommandButton Linked To Locked Cell

Oct 20, 2006

I have created a simple excel document with

Sub randomnumbers()
Range("B1").Formula = "=randbetween(1,100)"
Range("B1").Value = Range("B1").Value
End Sub

There is a button that i click and it creates a random number to cell 'B1'. it works fine, but i need to lock the document so that the user can only access one cell... 'A1' when i lock the document, and i click the button, it gives me a '400' error. i think it is because the button points to a locked cell.

View 5 Replies View Related

Hide Column On Double Clicking Certain Cell

Feb 1, 2009

I want to hide and unhide column AI by double clicking on a certain cell, let's say S25. Can this be done?

View 8 Replies View Related

Combine Two Macros And Run Them On Double Clicking A Cell

Mar 20, 2009

I have two pieces of code. The first one puts a tick mark in the cell when you double click it. The second one hides column B of another sheet if the value in cell A1 of Sheet1 is "a". I want to combine these two codes so that when I double click cell A1 of sheet1 it puts a tick mark in the cell and hides column B of Sheet2 and clears the contents of range B2:B50 of Sheet2.

View 4 Replies View Related

WorkSheet SelectionChange Clicking On A Cell To Update

May 11, 2009

I have code in my Worksheet_SelectionChange.

However it will not update until I physically click on any cell within the U33 to U38 range.

How do I tell Excel that I physically clicked on any of these cells? I have tried Activate..., blank and re-populate, select cell, select range... In VBA it does not think it is being clicked on.. it is just doing the code... when done I have to again manually/physically click on it.

View 9 Replies View Related

Change Cell Colour When The Protection Is Locked

Dec 3, 2009

Is there any way to change the pattern color of a cell (or a group of non-adjacent cells), say from No Color into Red if the cell(s) protection is locked (or unlocked)? Seems to me that the Conditional Formatting cannot work this way.

View 3 Replies View Related

Need Cells Locked Based On Text In One Cell

Aug 7, 2012

What I'm trying to do has been done before, However, all of the Code i am seeing online is not working for me...so maybe i'm missing something

I want a range of cells to remain locked unless SCP is entered. I need this done for four different selections (SCP, SD, MM, PP)

So if SCP is entered, then a certain range of cells remains locked, If SD is entered then another range of cells remains locked, so on and so forth for the 4 selections.

This was what I was working with.... However, i am not sure if i need to protect or unprotect the spreadsheet before i run the macro, also am i supposed to leave all cells locked or unlocked?

Private Sub Worksheet_Change(ByVal Target As Range)
If [B3] = "SCP" Then
ActiveSheet.Unprotect ("PASSWORD")

[Code].....

View 1 Replies View Related

Allow Drop-down Box Selection Linked To Locked Cell

Nov 30, 2007

We have Microsoft Excel 2000 and i have locked all worksheets separately. I have enabled Data Validation on a range of cells and enabled a list box. The way the workbook works is you log in with a name, the cell range references the names in each cell to another cell which was your login name. Those that match, after clicking a button will unlock those specified cells.

Then users can use the data validation listbox function to select only their name from the cell that was linked to the log in name box. (the users name that logged in only shows in the list). The problem is, all cells by default are locked in the range with the names in. You cannot delete the values in any other way, unless you unlock the cells. (at least thats what is supposed to happen)

My question is:

Is there any code anybody knows that i can use to make excel copy what excel 2003 does, im sure that the problem is a fault with excel 2000 and microsoft fixed it when they released excel 2003.

View 2 Replies View Related

Allow Cell Formatting On Locked & Protected Sheet

Jun 22, 2008

I have locked some cells on my Spreadsheet so other people can not change them. What I would like to know is how do I change the colour of the font? I also would like to Bold/unbold the font.

View 6 Replies View Related

Using Different Cell Values Into Different Textboxes By Clicking 1 Cell

Jan 31, 2013

I want to put my cell values into textboxes by clicking 1 cell

So example. I click B2 as active cell, then i would like to put all the values from row B (B1 : B10) in to different textboxes!

View 1 Replies View Related

Input Cell Address In Vba By Clicking That Cell

Jan 22, 2007

Is it possible to input a cell address in a VBA macro by clicking in that cell?

View 9 Replies View Related

VBA Changing Color Of A Cell Using Clicking On Another Cell

Mar 4, 2010

i want to click or roll over a cell with the mouse, to change the color of another cell, or another multi cells.

another question.
Is it possible to change the color of a pic i put in the excel using a function or VB.

View 9 Replies View Related

Add Active Cell Data To Cell By Clicking

Jul 19, 2007

I want to automatically put information from several cells into one cell, when these cells are clicked. Let's say that A1:J8 is the range were a cell can be clicked and if a cell is clicked in that range the value of these cells should be put in cell A9. If possible I want to avoid private subs in a worksheet. I preffer to have a macro running, so I can decide when to stop this routine.

View 3 Replies View Related







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