I know this will come as a bit rude, but since I have seen this scenario before, here goes:You haven't even tried locking/unlocking cells, protecting/unprotecting sheets to see what it does, HAVE YOU??????If you got off your butt, and unlocked the cells you wish the users to cut/paste into, while protecting the sheet, you will find that:Users can cut and paste.Users cannot delete rows, insert rows, deleted columns, insert columns, etc.What makes you think any of us come by this information in our sleep, or through divine inspiration? WE BUST OUR BUTT PLAYING WITH THE DAMNED SHEET, UNTIL WE GET WHAT WE NEED. Thanks, everyone.Here is the story. I used the template last year. I unlocked the input cells, protected sheet/workbook with password and give specific instructions to my users 'please do not CUT and Paste'. Since the workbook was locked, they could not insert/delete rows/columns or any locked cells but they still ignored my words and CUT/Paste within the Input area which was unlocked or unprotected.When they cut Cell1 and paste into Cell2, the reference Cell in another worksheet lost its reference.
![]() ![]() ![]()
Sample period. Digging deeper, we find that this is due to their performance in the US being much worse during the GFC than was the case for the other markets. The remainder of the study is organised as follows. In Section 2, we compare the cross-sectional and time-series momentum strategies. Section 3 and 4 discuss the data and the. Convert PDF files to Tiff files. So as mentioned the first step is to convert it into PNG file and then using JAI convert the PNG into TIFF. In the PDFBox, the PDFImageWriter calss is used to convert the PDF to the desired PNG file. However, the PNG file is created in the Filesystem. As i need to convert this further to a TIFF file.
It gave me a lot of headache. So what I am trying to do this year is to prevent my users from cutting and pasting. They cannot find the button, they cannot use short-cut keys, they have to correct mistakes by manually key-in or copy and paste.Now I am working on some codes to remove Cut from rightclick button list as suggested above. Not quite there yet.Thanks again for all your help.lmm2001.
IT's not possible to cut a protected cell.if there is a formula in there, then lock the cell.Copy a protected/locked cell, certainly. Cut a protected/locked cell, No Way. Check your code, don't reveal the password, make it a longer password. If you use VBA, then protect the project (from the VBA editor).When you follow up with your users, do their memories of what happened agree with your suspicions? If they insist they didn't do what you accuse them of, then dig deeper.How many formulas? You might want to consider removing the troublesome formulas from the sheet and have WorksheetChange do the calculation.My current project has tons of validation, cross-cell checking, etc., the only formula I use is in three cells: Today.Also, WorksheetSelectionChange may be of use, though I haven't used it.
You could use the Intersect method and MsgBox users when they are where they shouldn't be.But actually, now that I think of it, the best way to keep users out of locked cells is this:sheet1.EnableSelection=xlUnlockedCellsIf there is a formula in the cell, they have no business there, correct?They can't select the cell.And possibly:Worksheets(1).ScrollArea = 'a1:f10'Which keeps them in the specific boundaries of the designated area. Also keeps them from selecting the entire sheet and pasting into another workbook; disabling the protection.These commands would be placed in workbookOpen.Yes, it's true, if macros are disabled, the safeguards won't be there. Is your problem malicious users, or unskilled users?You can't stop a malicious user, just the unskilled ones.You also need to make sure you and you only have Write privs on the folder where the file is stored. If you use SneakerNet, then by all means burn it onto a CD-ROM.This is one possible scenario to corrupt a workbook:Copy the sheet, paste into new workbook.Save the workbook as the original workbook's name, back into the original location.No More Protection.If you aren't the only person capable of writing to that folder, then perhaps the above scenario is what happened?Of course, if the PageSetup is intact, chances are the corrupted workbook is the original workbook.This message was edited by stevebausch on 2002-09-11 16:56.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |