security

Hi, I need to know if it is possible for a macro to run if a specific worksheet is unprotected? For example, if someone takes off the protection to my costings sheet either through VBA or finding out the password, i want Excel to run a certain macro if possible? Thanks in advance Tom

OK, so a flair for the dramatic. That said, I worked very hard on a particular model and I would like to make anyone who has any intention of borrowing portions of the model very frustrated. Assuming that a potential recipient will receive the file via email...

Hey All, I have the following code that produces a summary from an excel workbook that that sends to an email address. The problem Is, I get the message "A program is trying to send an email message on your behalf". THis means it can't be automated in its current state. Sub...

Hi guys. Is it possible to set security levels of access to different sheets or even cells to not be viewable without a password entry? Basically I have a standard Personnel files containing categories such as. Personal Information Banking information position information performance review...

Hi all I have a workbook with a management dashboard - let's call it the central workbook - that collates commissions and performance data for our sales people from various other workbooks which are managed by leaders. Currently, we keep all of the aforementioned workbooks in a folder that only...

Does anyone have a tip to prevent iPad Numbers from basically totally unlocking ALL security settings on an Excel file. I want to share a locked up file, but if my contractors have an iPad and they download out of my Dropbox onto Numbers, the file security is totally wiped clean. Ideas?

Evening,I have got a spreadsheet with highly restricted information in it, as such I am trying to lock it down as much as possible.So far I have stopped copying and pasting, printing and saving to other location or with other filenames.Is there a bit of code that I can put (I assume in the open...

I want to be embed information into a spreadsheet (file) that will allow me to track when the file is sent out of an organisation via email. The background to this is: An intranet application needs to provide excel download functionality, we want to be able to embed a set of bytes (byte array)...

I want to limit a workbook to only be open by one person at a time. I know it default to allow read-only access, but I am running a lot of VBA from button clicks that should only be usable by one person on a first-come-first-serve basis. How can I lock out all other users when the excel workbook...

Dear Sir, my user enters data in one file. which has 5 column table.. i want when he/she closes the file after entered all data,. then after that he/she could not change any previouse entry.. only authorised person could do that.. is that possible?

I have an Excel2003 workbook which collects & summarises data from nearly 100 individual CSV files. For ease of use, macros are used to help navigation. The CSV files are updated every night. I want to also update the workbook automatically every night. Is there a way in VBA to 'Enable'...

I'm using Excel 2003 with IE8 If I save a New, Empty Excel Workbook as a Webpage, when I open it with IE8 I get a Security Warning "To Help Protect your security...IE has restricted this webpage from running scripts or ActiveX controls..." even though the Workbook is Empty Is it possible...

Hi Everyone, I am trying to create a macro to enhance the idea behind "For Internal Use Only." I have a button that will do the following I would like it to disable Reply, Reply to All, Forward I would like to disable the ability to Copy and Paste (or modify the message body). I would also...

Hi, I'm just wondering if it would be possible to add some code to a file that I have so that if someone copies the file and then tries to save it as some other file name, it will automatically erase all of the code contained within the project. Any ideas if this is possible?

Hi all, i have a spreedsheet that has macro's and vba code. The issue i am coming across is that a couple of computers in our organisation aren't working with the vba code in particular. i have set the trust centre settings to enable all macros and also have ticked the box to Trust access to the...

using =BDS(..."cols=6;rows=69") as my formula, I would like to pull just the number 69 and enter it into another cell. This number, 69, is automatically populated within the formula. To clarify, the number, 69, is not the resulting output in the cell... it's part of the formula. Also, this...

I hope someone can help. I have got two sheets, one with a reasonably large table of data of information held about individuals and a second sheet which is to be used by the end user. The end user will enter their name, date of birth and their unique reference number and based on the...

Hi I have a workbook with multiple sheets that I intend to put on a public server at work. However, I only want certain sheets to be accessible to certain users. Obviously, the ones I want no-one to see can be hidden, but of those remaining, I want some people to have write access on some of...

I created a workbook where one of the tabs is a map composed of seperate freeform shapes. When you click a state, it runs a filtering/copy-paste code which brings up a userform listing sales data for that state. My problem is that it was created using Excel 2010, I saved it as a 2003 xls. and...

Hello! If I were to build some macros for a workbook, is there any way to extend these to other workbooks? For instance, if I were to be downloading a new excel spreadsheet once a week, is there a way to have the macros already available on the new spreadsheet without having to copy them...