()Formula Enhancing Visiblilty Of Security Stock
Oct 30, 2007Need your lights pls to figure out how much times (monthly figures) my stock on hand will cover the demands. For instance: .......
View 9 Replies
ADVERTISEMENT
Cell Update With Real Time Stock Quotes For Particular Stock
Aug 7, 2012What is the easiest way to have a cell update with real time stock quotes for a particular stock?
View 4 Replies View RelatedStock Order Sheet To Be Created From Stock Inventory
Jan 8, 2014I have created a stock sheet on Sheet1, i have say 100 items and each item has a min and max stock order. Once the item hits a min low, the last cell (O) will display an order needs to be placed.
I was wondering if there way a way that on sheet2, it can calculate all the data on sheet1 and if there is stock that needs to be ordered, it will appear on sheet2?
This way i can just print sheet2 and send it to the supplier without having the entire 100 items displayed -if it does not need to be ordered?
Using One Formula To Classify Stock Quantities?
Jan 27, 2014I have been trying to work with to get my stock table classified into 3 different stock statuses and it comes out, it does not work I have attached the table as it is, the formulae I wanted to use and the end result I would like to have.
View 7 Replies View RelatedIF Formula - Identify New Stock Items In A Spreadsheet?
Mar 27, 2009I have two spread sheets from one of our suppliers, one was issued in 2008 and the other 2009. The newly issued sheet has about 400 extra items. How can I identify these new items of stock easily. I have attached both sheets for you to look at.
View 5 Replies View RelatedMacro Security (saying That The Macro Security Level Is Too High)
Nov 18, 2008I have a sheet that will not let me use macros. I can record them, but when I go to use them it says that the Macro security level is too high. I change it to Medium or Low but it doesn't make a difference.
The same spreadsheet works with Macros on another computer, but not my main one.
Enhancing Conditional Formatting: Write "NO DATA", "HIGH", "GOOD", "MODERATE", "POOR", "BAD" Depending On The Value
Jul 6, 2006I would like to write a function that enhances conditional formatting capabilities in this way: suppose that cell(4,5) contains a number that can be 0 to 5
in the adiacent cell(4,6) i want to put a function that:
1) write "NO DATA", "HIGH", "GOOD", "MODERATE", "POOR", "BAD" depending on that value
2)Choose color font depending on value
3)Choose color background depending on value
I wrote this piece of
Public Function StatusResponse(AdiacentCell As Range) As String
Dim thisStatus As String
Dim ThisFontColor As Integer
Dim ThisbkColor As Integer
Select Case AdiacentCell.Cells(1, 1)
Case Is = 0
ThisbkColor = 2
ThisFontColor = 1
StatusResponse = "NO DATA"............
Formula Not Working: "CCY Mismatch" And If "#N/A Sec" Then "Security Not Found"
Apr 29, 2009i just tried the below formulae but its not working. if Currency in col A and Currency col B is same it should be "Matched" if not same the "CCY Mismatch" and if "#N/A Sec" then "Security Not Found"
View 3 Replies View RelatedAre You Sure - Security For Macro
Aug 7, 2007I have a spreadsheet that I regularly have to clear the data and start over on, so i recorded a macro for clearing this rather long sheet with only one cllick.
My problem is that i am not the only person who will use this sheet, if They click the control button by mistake they will clear their work and you cannot undo it. I was wondering if i could make it ask "are you sure" kind of like the save option when closing an unsaved document.
VBA Security Options
Oct 12, 2009We have developed an Excel workbook with hundreds of lines of VBA code written for a specific application, and we would like to protect it.
Could someone give me an idea of what security options we have over and above the below (if any)?
We have protected all sheets and the workbook itself with passwords. The VBA itself is protected with a passoword.
My understanding is that VBA can be hacked into quite easily.....is there any way of adding another layer of security/protection without having to move to another platform altogether?
VBA Module Security
Dec 17, 2008i am going to ask is for my curiosity only and to be sure that no one will break my password.
If the VBA module is locked for viewing and password protected, it can't be cracked??I asking this, because i made an excel application with macros, and i don't want the user of it to crack my password.
I have to mention that the password is 17 letter+spaces long.
I repeat again....i asked this ONLY for my application safety.
Macro Security
Jun 29, 2006If there is code attached to a worksheet, not necessarily in a macro, does the macro security still have to be low to use it??
View 3 Replies View RelatedSecurity Code Input
Dec 7, 2009If I have a cell which has been validated and has a drop down list of 4 names in it.
I need it to prompt the user that when they choose there name and select, a window pop up or similar window appears asking for a 4 digit(or similar) code.
This is to stop others using peoples names against jobs they have completed so there is accountability if there are issues with information.
For each line I need it to re-prompt the user to enter the 4 digit pin so it cannot be tampered with.
Can anyone help with sending through a form and VB code possibly which I can copy into my spread sheet or a method I can use!
Social Security Number
Sep 8, 2009if there was a way to block out the last for digits of the social security number? list of numbers are in d4-d20
Ex
123-23-5785
would be
123-23-XXXX (with X's)
or how ever is supposed to be i forget the (standard) format
XXX-XX-5785
Cell Value Security Check
Apr 10, 2007There are 2 cells on my spreadsheet where individuals must populate $ values. I want to put a security feature in the worksheet that would create a pop up warning to the user that one cell must be greater than the other.
B26 (Client Assets) must be greater than B41 (Dollar Impact), otherwise a dialog box pops up to indicate to the user that B41 cannot be greater than
B26.
Security Against Password Hacking
Dec 12, 2007Is there a way to make excel less vunerable to hacking? We have a customer who is always breaking in and changing things.
View 4 Replies View RelatedSecurity Warning (Macros Have Been Disabled)
Apr 28, 2008I was playing around with Macros on an excel file. I created a few and ran them. In the end, I didn't like the way they ran, so I deleted them all. However since I ran them in the excel file, every time I open the file it gives me a warning saying
"Macros have been disabled."
Is there any way to remove the possible Macros ties/links from my file? I know I can disable the warning, but if I just want to remove the Macros ties to my file.
Security - Protecting A Paticular Sheet Only
Jan 7, 2009i have produced a spreedsheet on ms excel.
On sheet 2 is all of the information and tables etc.. for example prices and information for the combo boxes an such...i need to protect this sheet so no one can change anything on it
the problem is when i do so, and go back onto sheet 1 and say tick a checkbox or select something from the combo box is doesnt allow me to, the protection message comes up
i dont want this to come up on sheet 1, only on sheet 2!
i think its because i have links between the pages? like all of the info for the combo box is on sheet 2
Security Warning When Workbook Opened
May 30, 2009my workbook is finally working the way it should but every time i open it i get a security warning window with the options disable macros, enable macros and more info. how do i get this to not show up every time it's opened. this workbook will be used by someone other than me and i don't want them to need to do anything but open it and use it.
View 8 Replies View RelatedTurn Off Security Warning Regarding Macros
Jun 2, 2009I would like the security warning not to pop up when the workbook is opened. I have been able to turn it off for myself but I had someone else test it and each time it's opened the security warning pops up with the disable, enable messages. Is there a way to turn this off permanently so not matter who opens it it won't pop up?
View 9 Replies View RelatedMacros Dont Work Even On Low Security
Aug 21, 2009My dad wrote me a VB programme to save me time entering repetitive data into an excel template for my business. At first it didnt work untilll i reduced security to low. Sice then I fried my computer and have had to reformat it with a diffirent version of windows, vista service pack 3. Now even on low security it doesnt work.
The little button in the worksheet to make the macro happen isnt visible or doesnt exist.
VBA To Determine If Federal ID Or Social Security #
Jan 29, 2010What would be the simplest VBA to determine if a cell E7 contains:
A federal ID always 9 digits with only one hyphen which is always after the 1st two numbers. For example: 12-3456789
or
A social security number always 9 digits with only two hyphens which are always 1 hyphen after the 1st 3 numbers & the other hyphen after the next 2 numbers. For example 123-45-6789.
In other words,
If Range("E7") = a federal id then
or
If Range("E7") = a social security number then
Sort Out All Bid Prices For A Specific Security
Jan 4, 2006I have a security order list. This consist of several columns most important are
Column A Column B
Sec a 15,00
Sec b 14,50
Sec c 16,00
Sec a 15,10
Sec a 15,70
Sec b 16,70
Sec a 14,80
The first column gives the name of the security, the second column gives the bid price.
What I want is that I want to sort out all bid prices for a specific security. Vlookup works fine but again it just gives the first record. How can I get all bid prices for security a on a new worksheet without blank cells. If possible I would like to have it sorted as well.
Xl Macro Cant Email Due To Outlook Security
Jul 3, 2002I've written code into excel that sends workbooks to email recipients. This works fine except for use on one friends computer. Of course it's the friend that needed the code in the first place.
What happens is that when the macro attempts to mail a spreadsheet an outlook popup occurrs warning that a macro is attempting to email a message. And so nothing gets emailed out!
JOB SECURITY- How To Make A VBA Script Expire
Apr 20, 2007method for making a VBA script expire?
I.e. it will only work for a specified time and requires the author of the script to renew it at a given point?
I want to be able to do this to strengthen my position as an independent contrator financially...and copy protect my work from unwanted exploitation
Some ideas:
1-MSG box requesting a pre-defined password to renew the time for the script to work along with contact info for the author
2-Ability to define # of days, months and or years the script will work
3-Ability to define the # of days, months and or years that a MSG box warning of pending expiration will appear
4Ability to define the # of days, months and or years that the renew will extend the use of the script with multiple pre-defined passwords allowing different lengths of time extention! Perhaps an encryption method allows you to in another excel sheet (say the comfort of your own home) generate at will a password that will extend a scripts life for 3 months?! They contact you again, and again you generate a "random" password that will extend the original script
5-Anti-hacking measures, using MS's built in security
This might be a useful way of extracting monies over time, for the use of a script you provide....pre-set
Macro To Compare Security Codes
Jul 18, 2008I have 4 worksheets in a workbook: “choose security”, “download”, “MC” and “Lending”,
In the choose security” worksheet in CELL A2 is an HEX code, i.e. stock code.
2. In MC worksheet is raw data of all holdings related to various p’folios and securities, the information we need from this worksheet is,
a) p’folios, which are in column A,
b) Holdings which is Col B
c) Security code i.e. stock code which is in Col D
I need a macro or a formula to look at what security code is in “choose security” worksheet CELL A2, then look for this security in worksheet “MC” Col D, once matched, copy the data for this security to worksheet “download” and paste in CELL A3, I only need p’folios and holdings to be copied to “download” so data in Col A and B.
Once data has been copied to worksheet “download”, I then need another macro or formula to repeat step 2, but this time the macro will be looking at worksheet “Lending”,
a) P’folios, which are in Col B
b) Security code is in Col D
c) Holdings is in Col H
Once the macro or formula has found a match of security code, it will then copy the data from Col B and H to download worksheet CELL E3.
Without Prompting For Any Macros Security Message
Aug 28, 2008i want my application which i build though VBA in excel run on every computer without prompting for any Macros security message so is there any solution?
View 9 Replies View RelatedActive Workbook Refreshall Security
Nov 4, 2008I have a function that is called in Access vba code that refreshes all sheets in a given workbook. We use it all the time for workbooks containing any number of tabs to be refreshed. The code has a key line: ActiveWroksheet.Refreshall. I need to now start to secure the pivot so the user can not refresh it. Another post pointed me towards: .PivotCache.EnableRefresh = False.
This apparently can only be used for a particular sheet; ie it can not be applied to ALL sheets in the workbook. The trouble is the function is generically used to refresh any workbook, and the number of sheets may vary.
Any thoughts on how I can disable the ability to refresh a pivot for ALL sheets. I'd prefer not to turn off the pivot wizard since the user should be allowed to manipulate it...just not refresh it.
Security In Table/list Database
Jan 28, 2009Is there any lock/security option in excel sheets, suppose we make some table/list and after entering one data when the cursor goes to second raw, the previous raw data automatically lock. the user cannot edit or delete that record.
View 10 Replies View RelatedTrusted Macro Regardless Of Security Setting
Oct 22, 2009I've been told the latest Excels will allow any workbooks in a certain folder
to run macros as trusted (regardless of security setting?).
Can anyone confirm this please? Is there more to it? What versions are affected? Mine is 2003 so I can't check for this.