Protect My Stuff

Jun 1, 2009

my worry now is to protect my program from being played with as a lot of people ,some not so bright ,have access to my sheet can i protect my sheet and still have the macros function.

View 9 Replies


ADVERTISEMENT

For Each Row - Do Stuff

Aug 8, 2007

I have a script that i want to run for each row on my worksheet, but don't know the correct way to do a foreach using VBA.

For Each row ...

Do this code

... end for each

View 9 Replies View Related

Inserting Row With Stuff On Clipboard?

Dec 14, 2011

Sometimes I need to copy something to the clipboard, then go to another sheet (or somewhere). When I get "there", I sometimes want to insert rows, without "inserting cut/copied cells" . . . . So I end up saving the worksheet to clear the clipboard, then inserting my rows.

Can I insert blank rows while maintaining my clipboard?

View 3 Replies View Related

Dropdown List Or Autofill And Stuff?

Feb 19, 2014

I have a list of model numbers that corresponds to part numbers i.e:

model number
part number

abc
123

def
456

[code]....

I can type in A2 = ab and it autofills the model number abc, and have B2 automatically have the part number which is 123 filled in as well.

View 4 Replies View Related

Read Stuff From Closed Files

Dec 18, 2007

I would like to create a single excel file, which is composed by fragments of different (closed) excel fies (it should take some data from the files).

View 10 Replies View Related

VBA Stuff- Weight Watcher Spreadsheet

Nov 4, 2008

I have a Weight Watcher spreadsheet. I enter the Calories, Fat and Fiber and I get the # of points for that food. Then I keep put those points into the lower part of the spreadsheet where I track what I eat, and Excel does my simple math for me. What I want to do is keep a list of my foods, and their point value in my spreadsheet. I would like to be able to put the food name in Cell A1, the WW points in BI, and then be able to click a button with a macro that takes those two pieces of data and add them to bottom of my food list. I don't have a food list yet, I would assume I can just put it on sheet 2. I then want to be able to use lists in my cells to choose the food in the future. I need to be reminded how to make "dynamic named ranges. Today, I just need to know how to write the macro to copy and paste those two cells in the first open row at the bottom of my food list.

View 9 Replies View Related

Print Preview Shows 2 Pages But Only Have Stuff On One

Apr 29, 2012

When I view my page on print preview it shows 2 pages but I only have stuff on one page the second page shows 2 border marks but when I go to erase them I can't find them. Is there some way that I can find them other than look at page after blank page.

View 4 Replies View Related

Speeding Up Macro Process (Graph Algorithm Stuff)

Jul 7, 2009

i'm working on floyd algorithm macro for a project,
problem is, the spreadsheet matrix is huge, it's a 1043 x 1043 spreadsheet
And this is taking wayyy too long, i've been waiting for almost 2 days already..
here's the file :
http://ifile.it/6v2j39f
(You start the macro using "run" command in "input" sheet)

So is there any way to speed it up?
Or if anyone got a supercomputer, could you help me process this? :p

I'm thinking about changing the 10^5 value into infinite value, but i can't find a way to display infinite value..

And here's some reference for Floyd's algorithm,
http://ifile.it/12p5zle

I have tried to split the algorithm to make it process one iteration at a time, but i've been waiting like 2 hours with no result,
and that's for 1 iteration, can't imagine how long it takes for 1043 iterations
You can do this by deleting the.

View 14 Replies View Related

Excel 2007 :: Macro To Delete All Data Before Pasting In New Stuff

Nov 25, 2013

I am using Excel 2007 and have a simple enough macro to paste data in to another sheet - simple is what I do best.

Sub Macro1()
'
' Macro1 Macro
With Sheets("data")
.Range("B3").PasteSpecial xlPasteAll

End With
End Sub

I am wanting to change this so that before it pastes any data into B3 it will delete all data from B3:AE22.

I have had a look around and found plenty to delete full rows or worksheets but not just to delete the data in those cells.

View 8 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

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

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

How To Protect Sheet

Jul 10, 2014

I make excel file that contains certain formulas and graphs. Now I wonder is that a way for protect that file so it can be used only on specific cumputer, so if someone copy that file and paste it on their computer file will not work properly

View 1 Replies View Related

Protect The Range

Apr 5, 2007

i have a sheet that i write the date in Column D ,

A B c D
code name amount date
1 123 nasser 12.333 01-04-2007
2 123 nasser 122.333 02-04-2007
3 123 nasser 122.333 03-04-2007
4 123 nasser 122.333 04-04-2007
5 123 nasser 122.333 05-04-2007

what i try to do is to protect the range from A1 to D4 , which means to not edit any data in the day that before today , and to do it automaticaly every time i open the sheet
how to make that micro

View 13 Replies View Related

Protect An Addin

Nov 18, 2008

I am trying to protect an addin I have. I can protect the shared woorkbook, but when I save it as an addin the code is visible to the addin.

View 2 Replies View Related

Protect Call

Dec 8, 2008

I can protect my all sheet in excel but How to protect single cell or column, row? Is there any code for protect.

View 14 Replies View Related

Protect Workbook

Jan 19, 2009

Is there a button to protect a workbook in the same way that you can protect sheets? For example, I don't want a user to be able to touch any locked cells and there's multiple worksheets in this workbook. Do I have to go to each worksheet and protect them or is there a button to protect all worksheets at once?

View 3 Replies View Related

Protect The VBA Of Workbook

Mar 27, 2009

I have created an Excel workbook and protected the sheet. However, it still allows me go into the VBA section (Alt+F11) and edit away to their heart's content.

How can I protect my spreadsheet, as well as the VBA associated with it?

View 4 Replies View Related

Protect A Worksheet From Changes

Apr 24, 2009

how to protect a worksheet from changes so that I am still able to change one cell on the worksheet but not any other cells.

View 2 Replies View Related

Protect By PC Serial

Dec 5, 2007

is there a VBA that can protect the workbook by the computer serial Number .. so it won't work on another pc than this?

View 14 Replies View Related

Protect Sheet

Jan 21, 2010

My user form has a line of code that protects the sheets and does not allow any changes and selection of cells. It worked great on my personla computer.

Running the file on another computer the code does not protect the sheet. The strange thing is that if I go the Tools>Protection> the options is set to Unprotect. That measn that the code actually has protected the sheet but I am still able to make chages. If I manually unprotect and again protect the sheet, it is protected till the time close the file and open it again.

View 11 Replies View Related

Protect Buttons ...

Jan 24, 2010

Dear sirs,with best regards,i have in attached example file some cells i have protected them by ( tools-protect ) which is the general way for protection,for special purpose i ask you kindly to help me by:

creating a buttons with macros to protect and unprotect the ( cells,columns,rows,and all the sheet) that i need to protect them, when i want to (protect or unprotect) i have to click these buttons.

View 6 Replies View Related

Password Protect A Tab

Dec 9, 2008

is it possible to password protect a tab (worksheet) within a multiple worksheet file.

View 9 Replies View Related

Protect The Particular Cells

Apr 17, 2009

How can i protect the particular cells
Ex.

All the column g

View 9 Replies View Related

Protect The Sheet

Apr 21, 2009

Excel file 1 has:
Sheet 1: Account numbers and balances
Sheet 2: Mapping information detailing what account in file 1 is to go to a different account number in file 2.

Excel file 2 has:
Lots of sheets where information is to be keyed in.

This is a very manual process with lots of data entry to input into accounting forms I send to our head office. The "file 2" has sheet protection on all sheets so that formats, data, columns etc etc cannot be altered and only certain fields updated.

I think I have successfuly written my scripts to loop through the account values and map those to all spots in all sheets they are referenced to on the mapping document, however I am getting an error message that the "cell or chart you are trying to change is protected and therefore read-only".

Basically I look through the sheet and look for my mapping code, if that matches, I add the balance to the exisitng value of the cell, in the next column.
i.e. if B2 has the corresponding code I will add the balance to the current value of cell C2.

This is an extract of the code where I am looking up the sheet:

Dim ws As Worksheet
For Each ws In Sheets
If Left(ws.Name, 2) "OP" Then
Dim rg As Range
Dim cl As Range
Set rg = Range("A1:IV65536")
For Each cl In rg
If ActiveCell.Locked = False Then
If cl = kessanid Then
cl.Offset(0, 1).Value = acctvalue
End If
End If
Next cl
End If
Exit For
Next ws

It may be that because the sheet is protected as a whole nothing can be done but I was hoping that because I am going to the specific cell which allows input I should be able to do this.

View 9 Replies View Related

Protect On Close

May 22, 2009

I've been given this before but unfortunately i lost a hard drive so all the codes i was given from folk on here have been lost.

I had one in particular, where it would protect my workbook when closing so when it was reopened the user had to use a password in order to change protected cells. This was because certain colleagues would forget to protect the workbook and left it open to accidental damage.

View 9 Replies View Related

Protect A Particular Cell

Aug 1, 2009

I want to protect to cell in a worksheet. what i want is whenever i going to change the content of edit the cell it ask for password the two columns are
H2 & I2

View 9 Replies View Related

Protect The Workbook

Feb 15, 2010

Excel 2007. I have the workbook structure protected with a password. When I open the file, the worksheets are sized to file the normal Excel window space. When I email the spreadsheet to a customer who also has Excel 2007, the worksheets are small and she has to use the arrows to navigate.

We tried changing her view and that didn't work. She does not have the arrows available to resize the window. The only way I could fix it for her was to remove the workbook structure protection. I'm nervous about leaving it this way for our entire customer base as they could unhide hidden sheets and even delete them. Has anyone else experienced this? One more thing, customers that have an earlier version of Excel have not had this problem. This workbook is save as an .xls to be backward compatible.

View 9 Replies View Related

Protect The Macro

Jan 6, 2006

How can I protect a macro from other people changing it?

View 6 Replies View Related

Protect Message

Jun 14, 2006

I have the excel file where I have one protect sheet. But I need hide Message box which shows when I press key on cell, which is locked.

I tried set

Application.DisplayAlerts = False

in procedure Workbook_Open(), but it isn't solution.

View 4 Replies View Related







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