How To Protect Shapes From Being Inadvertently Moved By User

Feb 5, 2014

I did create a group of two shapes. One square and one circle. The main reason behind grouping them is to have them rotate around the same centre.

Now the problem of the usage of the shapes. I don't want them inadvertently shifted by the user. The rotation of the circle will be wobbly.

The circle is rotated by a module. Protecting the sheet makes the rotation of the circle stop working.

My thought was to overlay part of the sheet by an Active X label and set the BackStyle to transparent and there is no need to protect the whole sheet.

The problem now is that when I click on the label it turns white, and as soon as I move the cursor out of its perimeter the "underlying" circle will become visible again.

How to prevent this behaviour of the label. I want the label to stay invisible and protect the underlying shapes from being moved.

View 2 Replies


ADVERTISEMENT

Moved Workbooks To Folders Now User Form Subsript Out Of Range

May 19, 2008

The attached workbook has a userform which was searching the same folder where this file is located for entries in columns "A" and "B" of files named in column "I" (workbook1, workbook2 etc).

I have this placed on a sharepoint and want to move the files into specific folders (folder1/workbook1, folder2/workbook2 etc.) so I can set them as view only folders to stop unuathorised editing.

I am now getting a "Subscript out of range" error after doing a search. I can see it's a problem with the file name as it's pulling it from text in a cell but can't work out!

View 9 Replies View Related

How To Make The Macros Keep Working Even If The Sheet Is Moved Or Mailed To Another User

May 26, 2009

I have created a workbook ( with protected sheets) containing two macros " To Insert a Row ( Copying the formula from the row above) and "Delete a Row", both, assigned to a customized toolbar.

when I move the workbook, say from the folder where I created it originally to the desktop, the macros stop working giving error like THE MACRO " C:so n so... CAN NOT BE FOUND!

View 9 Replies View Related

Inadvertently Saved Over An Important File

Jun 10, 2008

I'm not sure how I did it, but I opened up a new Excel file and accidentally saved it over a file I've been working on all afternoon. Is there any way to recover the original file (per the last time I saved it about 20 min ago)?

I looked in the "wastebasket" and only found files that I had specifically DELETED. But I didn't specifically delete this one, instead I saved over it.

View 9 Replies View Related

How To Protect Cells After One User Input

May 2, 2007

I want to administrate a short training test. The user has chooses a correct answer A-E, off a drop down menu. I want to set it up so the user can't answer multiple times until they choose the correct answer.

View 14 Replies View Related

Protect Source Code From User

Aug 26, 2009

how to protect source code from user or give the password when the user view code, right click on a sheet.

View 4 Replies View Related

Using VB To Password Protect From User Form

Feb 16, 2010

I have coded a user form to automatically unprotect a sheet, then protect it with a password after data is entered from the User Form. Works great. However, after it is protected through the User Form script, I cannot unprotect the sheet to edit it. It will not recognize that it is the correct password, although it is.

Private Sub cmdOK_Click()
Dim NextRow As Long
NextRow = Application.WorksheetFunction.CountA(Range("b:b")) + 2
Cells(NextRow, 2) = txtAddProvider.Text
ActiveSheet.Unprotect Password = "stats@fwh"
Range("B3:B21").Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort.SortFields.Add Key:=Range( _
"B3:B21"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
ActiveSheet.Protect Password = "stats@fwh"
End Sub

View 9 Replies View Related

Protect/lock Cells After User Input

Jan 9, 2009

Have a worksheet that will be used multiple times. User will enter name and employee number only on the first instance that the worksheet is opened. Would like to protect that info automatically for further usage. Most of the worksheet is protected but some cells need to remain unlocked so the "whole" sheet protection will not work.

How do I protect only specified cells, say F3, G3, H3, I3, after the user enters data thru an input box without changing any other protected cells on the sheet?

View 3 Replies View Related

Protect Some Cells Of A Spreadsheet From User Input (by Typing Only),

Mar 15, 2009

Is there a way to protect some cells of a spreadsheet from user input (by typing only), yet letting button controls and VBA macros modify the values of those cells?

I need to prevent users from accidentally deleting formulas or values generated by VBA macros or controls, although they may delete values in some cells.

View 9 Replies View Related

Creating Shapes (Rectangles And Shapes) From Input Cells?

Aug 30, 2013

Im trying to create shapes Rectangles and Squares with different colours within an excel sheet, where the length and height of the shapes is generated by input values.

Also is it possible to create 3D shapes, again where the size of the shap is generated by input cell values.

View 1 Replies View Related

Change VBA To Password Protect All Sheets To Allow User To Select Protected

Apr 8, 2009

I need to change VBA to Password Protect all sheets to allow user to select protected. I have:

View 2 Replies View Related

Protect Sheet But Allow User To Unhide Specific Range Of Cells

Jul 19, 2014

All, can I protect my worksheet while at the same time allow users to unhide a specific range of cells?

I'm hiding cell range FA:FK, but based on certain conditions I want to allow the user to unhide the cells but I do not want the user to be able to unhide any other hidden ranges. if there is a way to do this without using VBA. If it cannot be done with VBA

View 1 Replies View Related

Moved The Sheet To Another Workbook

Oct 9, 2007

I have the following formula that was in a workbook. I then moved the sheet to another workbook and now no longer works.

=INDIRECT(ADDRESS(ROW('[book1.xls]1000'!A509),COLUMN('[book1.xls]1000'!M$1),4,,1000*A6))

Does the INDIRECT function not work for references to other workbooks.

View 9 Replies View Related

Password Protect Columns - Hide And Protect Ability To Unhide

Jan 17, 2013

Some sensitive data is held on worksheets that are used by people that do not have access to see the data.

It would be most convenient to keep the data in these worksheets but hide it from view of the users.

Is there a way to password protect a users ability to unhide a column?

View 2 Replies View Related

Moved Document Now Formulas Don't Work?

Jul 31, 2013

I have created two documents. One document (A) is my worksheet where I input data, the second document (B) is my spreadsheet where it comprises all my data into the fields I want. I have completed both documents on computer (1) and now need to transfer it to another computer (2). However my formulas no longer function after I move the document (A) from computer (1) to computer (2). Is there a way for me to work around this? Do I need to transfer the spreadsheet (B) to computer (2) in order for them to function correctly? How can I make it so I have the worksheet (A) on computer (1) enter data correctly into the spreadsheet (B) on computer (2)?

View 4 Replies View Related

Hyperlink - Update When File Moved?

Jul 20, 2013

I have a spreadsheet with hyperlinks to various file types (PDFs, Docs, etc.). Is there any way that I can have the hyperlinks update themselves automatically when I move one of those files to another location?

View 2 Replies View Related

Event Triggered When A Shape Is Moved

Jan 20, 2010

Is there a way to trigger a macro when a shape is moved by the user? If I set the OnAction property for a shape, then the cursor changes to a hand when it is over the shape, and I can detect a mouse click on the shape, but I cannot drag and drop the shape. If I reset the OnAction property to "" (empty quotes), then I can drag and drop again within the worksheet, but I can't trigger the macro.

Worksheet_Change or Worksheet_SelectionChange are not triggered by this event.

People have suggested using timers to continuously poll the shapes and determine their locations, but is there an easier way?

What I am trying to do is create a sheet where the user can visually move around objects (in this case representing employees) and deposit them in various zones. The spreadsheet would then apply certain attributes to the shape i.e. change colour according to where the shape is and if it is in an unsuitable zone. I can do all of this, but I want it to work the instant the shape is moved, not rely on the user to hit a button.

View 9 Replies View Related

Set Value From Cell Moved 1 Place To The Right Inside For Loop?

Oct 6, 2011

I have this loop, I get a range of specific cells and then I loop over this collection searching for a value, if this value exist I wanted to move one place to the right and then set a value on that cell, but for some reason when I put this offser(0,1) parameter, the loop became infinite, not sure why the code is doing this:

Code:
For Each c In Worksheets("Parameters").Range("A3:AR3").Cells
adress_start = ""
adress_letter = ""

[Code].....

View 2 Replies View Related

Visual Basic Editor Windows Moved

May 15, 2007

I have a problem with my VBA Editor. I have the Projects Window at the top left of the screen, the Properties underneath it and, normally, the Userform/Code window fillint the rest. However, The userform/code window is not behaving as before. When you try to get one or the other they open in another window whereas I'm pretty sure that they just opened in the same window.

View 4 Replies View Related

Array Formula Works In One Portion But Not After Being Altered And Moved

Dec 18, 2013

I figured out exactly what I wanted to do and got it to work in a test excel sheet. However, when integrating it into the actual workbook I wanted, I was unable to get it to work. So, I used the same cell references I need to work in my actual workbook and pasted it all back to the test excel sheet.

So, the test excel sheet has the working formulas up at the top, and a duplicate of what I need to work in the actual cells I need them to work in. Changing the shift start time should group any persons with the same shift togethor. I'm still fairly new, but I think the only portion that could have been changed is the portion that says 1:1.. I figure that is relative to the array so it shouldn't be changed, but not sure what else to do.

Here's an array formula that works:

[Code]....

Here's the array formula to be in the correct cells that doesn't work:

[Code] ....

How to to get it to work in the different cell area.

Attached File : Shift.xlsx‎

View 3 Replies View Related

Excel Document Margins Moved When Viewed On Different Computers

May 1, 2013

I have designed an excel spread sheet for my staff to fill in when completing care plans - there are a lot of drop down boxes etc., on the form - when it comes to printing 3 computers on the office print it fine but the other 3 the margins seem to move and the sheets come out totally wrong - I have checked the setting and we are all using the same setting etc., but it is still happening - we are also all printing to the same printer.

View 1 Replies View Related

Excel 2010 :: Hyperlinks Not Working When Spreadsheet Moved

Oct 17, 2013

Using MS Excel 2010.

As I understand it hyperlinks set in a spreadsheet should work regardless of where you save and/or copy the spreadsheet i.e. as long as the directory location of the location / file the hyperlink is referencing doesn't change (notwithstanding, the user must have appropriate access rights to the relevant directory locations)

However, the situation I have is the spreadsheet was generated and saved to directory location A (intention being this would be the 'master' yearly template) and the hyperlinks set, all of which work when you open the spreadsheet in this directory location. But when I copy the spreadsheet to directory location B, which is intended to be the yearly 'register' location for the spreadsheet, none of the hyperlinks work? When I hold my cursor over a link in the copied spreadsheet, in directory B, I do not get a 'pop-up' path like I do in directory A and when I click a link I get an error message:

Microsoft Excel The address of this site is not valid. Check the address and try again.

As stated above the documents the hyperlinks relate to have not moved, they remain in the same template directory (i.e. the link path has not altered).

View 1 Replies View Related

Failure Of Automatic Calculation When Worksheet Moved To Another File

Jun 1, 2008

I have workbooks in which summary tables are generated by lookup formulas. Tables are on different sheets but all use the same lookup value by referring to a cell on the 'master' sheet. The lookup value appears in cells on all sheets, by reference to the master sheet (e.g. [formula] = mastersheet!$B$2).

The master sheet contains the main summary table and is copied and detached for distribution, using a macro. For practical reasons, this is done in two stages, first copying the sheet within the workbook (to make minor alterations), then moving it to a new book to save and distribute.

This is where the problem arises. After the sheet has been detached, we find that if we now change the lookup value on the master sheet in the original file, the tables on that sheet will update normally, but the cells on other sheets remain frozen at the previous value and the tables on those sheets do not update.

The only way round the problem is by Shift + Ctrl + Alt + F9. (Maybe I should add that all my workbooks are always set to automatic calculation.)

The macro itself is not the cause of the problem; if we follow the same procedure manually, the result is the same. However, if we move the sheet in one step, eliminating the intermediate copying stage, the problem does not arise. But this is evading the problem, not solving it, and I would be reluctant to have to resort to this.

The original problem remains as stated, viz. failure of automatic calculation.

View 5 Replies View Related

Vba Shade A Cell Once Its Moved ( And Add New Rows Beneath ) Minor Code Adjustment

Nov 7, 2009

I've adjusted a jonmo code to add an item in col B which is not in col A to the bottom of col A. - fab code, thanks jonmo.

But.. i want to:

insert rows beneath those in column A to accommodate the added items and shade those cells in list A once they been added ( so the users now they've been moved )

I've posted the code below ( including my attempts at colour change where it shade the right cell but in the wrong column ) ...

View 9 Replies View Related

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

Jan 12, 2007

I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub

View 3 Replies View Related

Lock Cell After Data Entered And Have Moved Off That Cell

Jan 5, 2013

Currently have a column of cells that after the data has been entered we would like the cell to lock to prevent changes. The sheet is currently protected with the cells in question unlocked (D173:D250). We would like to be able to change the data if we unprotect the sheet. We would also like to be able to add/delete cells (list) in the code as needed.

View 9 Replies View Related

Copy Textbox Text When Cursor Moved From Textbox

Feb 7, 2007

In Excel VBA Userform, how to copy the text from textbox automatically when the cursor is being moved from the textbox. And when i put CTRL+V then the copyed text has to be pasted.

View 5 Replies View Related

Merits Of VBA Protect Vs Non-Protect

Jul 26, 2006

I would like to protect the intellectual property of an application and have read differing opinions of the merits of protecting VBA code. What are the opinions of the experts on this forum? Are the password breaker programs so advanced that protecting code is a waste of time and only a hinderance to debugging and troubleshooting?

I am using MS Excel 2003 (11.5612) on XP.

I apologize if this topic has already been covered on this forum. I searched but did not find exactly what I was looking for. I am happy to review an old post if one exists.

View 7 Replies View Related

VBA With Shapes

Dec 3, 2008

I have a macro that opens Word pastes data in from Excel,

I want to be able to paste an arrowed line that I have drawn, also if it changes, I want it to reflect that change.

Here's the
Item("Direction1").Range.InsertAfter Worksheets("BSID").Range("Line3").Value

I have my bookmark in Word setup, I'm guessing that instead of a cell ref I need the name of the Line, which is "Line 3" in this case.

I ran a recorded macro and copied and pasted the line and instead of "Range" I got "Shapes" so I assumed that I just needed to change these words but no joy.

View 9 Replies View Related

Working With Shapes

Mar 24, 2009

Where do I find a tutorial or examples to show me how to create bars for gantt chart in excel, based on date values?

View 14 Replies View Related







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