Prevent Users Opening In WordPad

Jul 11, 2006

I know how I can protect worksheet or a group of cells, but I can not prevent any one to damage it by (open with) WORDPAD to clean or damage it then to cancel this protection!

View 4 Replies


Prevent Users Overriding Validation?

Apr 3, 2009

This site provides a partial answer to my problem-

That link worked for me but there's a problem with it, it does not work if a table has different types of validations.

View 5 Replies View Related

Prevent Users *Selecting* Cells Using VB

Jun 2, 2006

I am currently setting up protection on an excel sheet - I have a proceedure to open a specific worsheet and lock and unlock cells according to whether or not certain information exisit. My question is, although I can lock cells and prevent users changing them using code I can't seem to stop them selecting cells in the first place - this is obviously achieveable from the 'Protection'>'protect workbook' menu but I want to do it from code since the sheet is unprotected and reprotected a number of times during a session....

View 4 Replies View Related

Prevent Users From Saving The Document

Jun 23, 2007

I have macros that pulls data from an SQL db. Users need the ability to modify the data on the worksheets BUT they can NOT have the ability to save the document.

Is there a way to disable the "save" function from the FILE drop-down box?

View 9 Replies View Related

Prevent The Users From Inserting Columns Within A Certain Range?

Jan 7, 2010

I am instantiating Excel 2003 from and populating the spreadsheet from SQL. The workbook itself will be maintained even when the .Net program is inactive (so that the column headers are established and saved.) Is it possible to prevent the users from inserting columns within a certain range?

View 2 Replies View Related

Prevent Users From Edit/change Formats Of Unlocked Cells

Sep 30, 2007

I have a spreadsheet that is very large and formated a certain way. I want to make sure that a user cant put the cursor in the lower left corner and copy cells by dragging, copy & paste, or do anything other than input data and be able to highleght text and reinput data in case they mistyped or misspelled the data.

ex: user clicks on cell E33 and types in '1234568' and then move to next cell. The user can click back on E33 and can correct by retyping. That is all the user is allowed.
The cells in question are also in ranges if this helps. EX: 'E33:AJ67'

View 9 Replies View Related

Prevent A User From Opening Another Workbook

Feb 12, 2009

How can I prevent a user from opening another workbook in an Excel session "from the outside"?

I'm fairly new to VB. I'm developing (in VB 2003) a simple but SECURE Excel environment which will allow a user to update a hidden Master_Records workbook. I need to keep the user's Excel session secure...for example, I've disabled all Excel Toolbars and Command Buttons, effectively preventing the user from doing anything except filling in some cell values and clicking on a few custom buttons in the worksheet. But how can I prevent the user from opening another workbook into the active session from his desktop and introducing some malicious code into the session via that route?

One respondent in another forum (the only one, in fact) suggested that I look into "instantiating workbook level events" so that I can detect when other workbooks are open. I'm not sure what that means, is there someone here who could give me some guidance into that solution?

View 13 Replies View Related

Prevent Spreadsheet From Opening When Being Updated

Jun 19, 2007

I currently have a spreadsheet that my deparment use at work. Its just a full time equivallent sheet, nothing fancy. However I added code onto it to prevent users opening it as I was updating it.

However I went to open it and It wouldnt open. It wouldn't recognise me as being the exception. Its just a code on the workbook open that says if user is "slb090" (which is me) then do nothing, else msgbox and just a quickie sayign come back later".

I have attached the spreadsheet, in the hope someone can open this for me and remove the message so I can open it!

View 3 Replies View Related

Prevent Email Code From Opening New Instance Of Outlook Every Time

Aug 28, 2013

the code always opens a new instance of Outlook even though one may already be open. If left unchecked I may have like 30 instances open if I leave the computer for a few hours. So I was wondering is there some snippet of code I can add in here to check if excel is open first and if so do not open a new instance?

Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
' Change the mail address and subject in the macro before you run it.
With OutMail
.To = ""


View 2 Replies View Related

If Macros Are Diabled At Security Prompt, How To Prevent Workbook From Opening

Dec 15, 2008

I am relying on macros for a lot of functionality and security.

Is there a way to stop a spreadsheet from being opened/accessed if a user disables macros at the security prompt?

View 9 Replies View Related

Wordpad To Excel

Jun 17, 2009

I am hoping someone can help me out of a problem i have. I have some numerical data (temperature readings) that was recorded / stored to a wordpad file.

I have to do some analysis of the data, such as finding mean / maximum and temperature differentials, which i thought would be as easy as opeining up the wordpad file in excel, and then doing formulas (such as =D7-E7).

However, i cannot get any formulas to cork - they all arrive back with VALUE and although all the data is numbers to look at, it might be stored as a text format? (my laymen knowledge isn't that great!)

am i missing out any steps to be able to use the data i have in wordpad as numbers in excel so i can use formulas?

View 14 Replies View Related

Open Csv With Wordpad

Oct 19, 2007

I would like to Use my Excel VBA program to do this:

User Selectable: Open a CSV file using wordpad.

Once the program is opened I would like to search each row in the document for a name (value of 5 as a unique identifier) if the name exists then I would like to delete the entire row.

After the whole document is done I would like to close it and save changes.

The reason that I cant do this using excel is because the file gets screwed up, whenever I try to do the above in excel, even when I save in csv format and everything. The file has to be procesed through a nother program once I delete the unvanted info that is very picky about commas and any alteration in excel results in the file being incorrectly used.

The only method that I found that works is when I MANUALY open the csv in wordpad delete the lines I dont want and then close and save changes. Using this method the other program acepts the chaged file without a problem.

I can write the code to use excel to do it and it seams preaty simple. If what I need requires too complex an answer then please dont worry as I probably wouldnt understand it anyway.

I have included the code that does what I want in excel but results in the csv file being unusable.

'Read in path from setup area on front sheet and open "Open" box
DPath = Cells(2, "C").Value & Cells(2, "D").Value
ChDrive (Cells(2, "C").Value)
ChDir (DPath)
strFile = Application. GetOpenFilename(" (*.csv), *.csv", 1, "Select your System CSV file in Price Folder (Double Click on it)")
If strFile = False Then Goto 1001

View 9 Replies View Related

Application Onkey: Prevent Users From Using The Print Screen Or The Alt Print Screen Buttons On The Keyboard

Dec 29, 2009

I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).

View 5 Replies View Related

Prevent Workbook Opening If Other Workbook Open & VBE

Aug 29, 2006

how to prevent a workbook from opening if another excel document is open and if a visual basic window is opened.

View 8 Replies View Related

Conversion Of Excel File To Wordpad?

May 22, 2012

I want to convert excel file having cheque no 11111 at A1 and amount 5000.00 at B1 in first line and in second line 231 and amount 155000.00. i want to convert this to word pad in the following shape


How can I convert it?

View 1 Replies View Related

Address Formatting From Wordpad To Make Mailing List

Mar 11, 2013

I have a data set for over 9000 addresses and can't get it formatted the way I need to. Attached is a small version of the doc. I need colums with "Name, address, zip, state, etc." and need to get rid of any duplicate addresses. address mock1.xlsx.

The main issue i'm running into is some of the addresses are 3 rows, some are 4 or 5. If there is a way to group all the data automatically between the "----------------------" that seperate them I think the offset or concatenate tools might work?

This document was originally wordpad in this form and I don't neccesarily need all the data, mainly need to make a mailing list. address mock1.txt

View 2 Replies View Related

Opening A File Without Opening A Workbook

Apr 17, 2007

I have a need to open a file from my companies intranet. My current method was to open said file via the method that the recorder gave me. However, I would like ot be able to open a said file without having to start open another workbook.

This is the path:

So the command is this:
Workbooks.Open [url]

Links are not actual links

So what I need to know. Is how can I open this file without opening a workbook. I haven't been able to use the VB "Open Statement" to open a file and I don't believe that I've been successfull using the Filesystem object either.

View 9 Replies View Related

Allow More Users

May 12, 2007

I am after increasing the number of allowed users that can log onto a form. Currently I have used someone elses code, but that seems to only allow 1 userID to be able to log in. I am not after making the sheet into Fort Knox, just a simple UserID so I know who hasd made any changes.

Private Sub CommandButton1_Click()
If txtuserid.Value = ActiveSheet. Range("b100").Value Then
End If
If txtuserid.Value = "admin" Then
End If

View 7 Replies View Related

VBA - Run Only For Specific Users?

Jun 3, 2014

I want to run an event for specific user. In this case, only John Doe should be able to run this command. It works fine if i put john doe in there and i get the MSGBOX since my windows log in is not John doe. But when I put my windows login there (and only I can run it), i dont get any msgbox or the rest of the command does not run..

View 10 Replies View Related

Track Users

Dec 15, 2008

We have an excel file that I've developed that people in our department are supposed to be using - not that they want to - but it is an edict from our bosses. Is there a way to track who is actually using that file so I can verify that they are using it rather than just relying on them saying that they are?

View 9 Replies View Related

UDFs To Other Users

Feb 27, 2009

Although I'm able to write UDFs and distribute addins, one thing I've found is that if you use a UDF formula on a sheet on one machine, save it, then open it on another, Excel doesn't automatically look in the local .xla for the formula. In fact it tries to find it on the network (expecting to locate the originating user's machine, I suspect) and then throw a strop....

View 9 Replies View Related

Allow Users To Edit Ranges?

Jan 2, 2014

I have a sheet which has many columns in it, all columns are protected except column B. When I want to enter data always I have to insert a column in column B. When I clicked insert button, my B column move to C and B column become protected and C become unprotected. My query is always I want B column should be protected (even if i clicked on insert column button too).

View 1 Replies View Related

Formulas Not Calculating For Some But Not All Users

Apr 21, 2009

I have a workbook that is linked to 2 text files and updates just fine for me but when someone else opens it it does not calculate the new information just keeps the old. New text files are ran from our database to excel every night. When the workbook is opened the formulas should recalculate based on the updated info in the text files. Problem is when I open the file it performs perfectly and updates as it is supposed to but when my colleague opens the file it is not updating and does not show the new updates. I have checked to make sure the calculation is set to automatic. I have also confirmed that we are both working with 2003 version. I even had her open the text files and close and reopen the workbook and no go. I hat her do ctrl+alt+f9, even ctrl+alt+shift+f9. Had her click on the function, hit enter and nothing. Even tried find and replace = with = to wake up excel and nada.

View 9 Replies View Related

Margins Change For Some Users

Mar 26, 2014

We use a spreadsheet for developing loans. I can open and print all of them just fine and so can almost all of the other employees. We have two people, though, that have the margins change when they open them. I can open it and have it be just fine, close it, they open the exact same file and see changed margins.

How to change that. I don't want them to have to do it on each spreadsheet. I am looking for a complete, one-time-only fix.

View 6 Replies View Related

How To Let Users Select A File

Mar 28, 2014

I am looking for a code to let users select an excel file like File Manager.

View 2 Replies View Related

How Do You Hide Macros From Users

Jan 30, 2009

I have created some macros and assigned shortcut keys. The workbook is shared by other users. I want to keep these macros from being accessible to other users. I know that they can go to ToolsMacros and display the names of macros and run them. How can I prevent them from accessing the ToolsMacros? Or can I assign password to individual macros?

If I put the macros in individual sheets as Private, they don't show up on the ToolsMacros list, but then I can't assign shortcut keys.

View 11 Replies View Related

Using Workbook By More Than One Users At Same Time

Jan 8, 2012

can we use excel workbook by many users at same time ?.

View 3 Replies View Related

Multiple Users To One Spreadsheet?

Mar 5, 2013

We have a place where all our documents are stored. We have a log where we all log in what we're working on. Our trouble is, if one person has it opened nobody else can add their items to it. Is there anyway to have multiple people be able to open and enter their work for the day, save and close it out?

View 1 Replies View Related

How To Share Macro(s) To Other Users So They Can Use It

Jan 7, 2014

How do I share a macro(s) to other users so they can use it? Each user has different location because we are working remotely.

View 1 Replies View Related

Preventing Users From Using Passwords

Mar 18, 2008

I have made an integrated timesheet for everyone at work. Problem is, people will be funny-beggers, and want to password protect their workbooks.

I want to be able to prevent EVERYONE from creating passwords to protect their workbook.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved