ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

8 Q & A posts tagged with password

Wed
Nov 16
2011

How to protect MS Publisher 2003 file with password?

I want to protect my MS Publisher file with a password so that no one except me could open it. Pl answer to ques with steps.


Answer

You can always use any Zip app to compress it with password

or, create a protected drive using TrueCrypt that holds these files

Get a free zip app from http://www.7-zip.org/
and TrueCrypt from http://www.truecrypt.org/

Wednesday 11/16/2011 9:09:44 AM
Sun
Nov 13
2011

Can I make A Log-In Box For a website With Just One Password for everyone to use?

I Recently Saw that www.wixlab.net has a log in like the one im asking for. you enter the password ilovewixlab It Unlocks The Downloading Feature. BUT all I Want Is For It To Take you to another Assigned Page. But if you know how to do Anything with this or what it is or where can i get it. i welcome you to answer please. Thanks!


Answer

Yes you can
You need to use cookies, based on your technology that used to build the site (php, asp, .net, cms, etc)
You can set the password entered by user to save in a cookie, then match it against the password you like.

let me know if that makes sense, I will be happy to do it if you want and if the technology is something I know

Sunday 11/13/2011 6:45:12 AM
Sun
Nov 13
2011

How do I kick an Xbox 360 from my WiFi network remotely?

I'm trying to torrent and download here but my brothers are hogging all the bandwidth playing on Xbox Live! The Xbox 360 is connected wirelessly to the network so is there a way where I can quietly kick it off the network, secretly allocate all of the bandwidth to myself, or just control my home wireless network without them knowing?


Answer

Yes, sure
Most wireless routers enable you to control that using its IP (like 192.168.0.0)
You should have that IP in the router manual
Once there, you can control who gets what
You can create password, refresh IP addresses, restrict access to only certain devices, etc

Sunday 11/13/2011 2:28:12 AM
Wed
Jan 21
2009

How do you make a password field in excel so when you type in one of the cells, it comes up as asterisks *****?


Answer

Excel cell does not allow you to do this, you need to do an alternative ways, you got two:
1- You can use the TextBox from Forms toolbar (If you have Excel2003) or from Developer tab (If you have Excel2007)
2- Add a VBA form and add the text box to it.

Wether you do 1 or 2 you need to change the password property of it to make it show you * when you type in it

Again Excel cells can not allow you to do that, forget it

If you need help in doing this, or you don't know how to add a VBA form or Textbox to your Excel sheet, mail me here

VBAXLMan

Wednesday 1/21/2009 2:21:07 PM
Wed
Jan 21
2009

Excel 2007 document protection & locked cells?

Hi,

I've created an excel document that numerous users will be editing, however I need for only certain users to be able to edit certain cells.

I currently am using the track changes method, however it appears that there are ways around this.

Does anybody know if there is a formula or a function I can use to only allow a user to edit a certain cell if the username = joe.bloggs for example? Excel can clearly look up the username as it does so in the "track changes" but its how do i use this information to protect my cells?

Many Thanks,
Mark


Answer

The Standard way is to give the password to modify the file (Save As > Tools > General Options) to those people only allowing them to edit these cells, while others can not

The other way is to lock these cells with password (Review > Protect Sheet) and give those the password

In addition to that you will always have the macro way, but that requires more info from you

Enjoy my profile, I am the VBAXLMan here

Wednesday 1/21/2009 6:55:16 AM
Thu
Jan 15
2009

Ms Excel macros problem ??? ?

it give the error

Macros in this workbook are disabled bcase the security leavel is high, and the macros have not been digitally signed or verified as safe. to run the macros , you can either have them signed or change your security level.

i reduce security level high to low , i also crate one password for that file also than after it give this error ?????

what can i do ???

give full information about this problem and how to solves ??


Answer

Excel does that even if your security level is low, you will need to enable macros

I can smell that you have Excel2003 or XP, then do enable when you open the file

IF you not enable the macros, you can not run them, whatever is your level of security

It should show you a window asking you if you want to enable macros

Click "Enable macros"

VBAXLMan

Thursday 1/15/2009 7:13:43 AM
Tue
Dec 19
2006

Excel Spreadsheet opens up blank?

Coworker wanted me to double check her work and when I open the spreadsheet it comes up blank (just gray) not even showing the columns and rows. But looking at full screen I can see it. All other excel spreadsheets are fine.


Answer

There are alot of tricks in Excel to do this, I just need you to check these one after another
1- Go to (Window > Unhide) and see if there are items shown in the dialog that appears
2- Go to (Tools > Options > Window options) and make sure you select (Row and column headers, gridlines, horizontal scroll bar, vertical scroll bar)
3- got to (Format > Sheet > Unhide) and check the hidden sheets

PS: If excel asked for password, then the file is protected, you will need it

Enjoy my profile, I am the VBAXLMan

Tuesday 12/19/2006 2:56:20 PM
Sun
Dec 3
2006

I have an excel file and I have forgotten the password. Is there a way to recover the password.?

I have checked the crack softwares on the internet. I am not ready to pay $40 for just 1 file. But this file contains some important tax info and I need to make some changes urgently. Is there any way I get recover the password.


Answer

I have one and ready to share it
I just want to ask, which password you are talking about
Excel do have at least three password levels

mail me here for it

Enjoy my profile, I am the VBAXLMan

Sunday 12/3/2006 11:05:59 PM

Tags

History