What is the code to hide my vba calulating on screen? I have vba doing a bunch of things (like updating values etc.) that I don't want the user to see while using the spread sheet.
View 2 RepliesI can't seem to make user-defined format that puts a text in front of a number and/or a text.
Let's say I have A1: 13, A2: texttext A3: text7 and I want to format a lot of cells to "Ilike 13" / "Ilike texttext" / "Ilike text7"... ie add the same text in the front of the cell, no matter what the content is.
I did manage it seperately, with "texttext" @ for text and "texttext" # for numbers, but what's the general one?
I have a challenge in excel functions, I need to save a file as common folder but in that workbook have multiple sheets need to show the sheets as per the user name on system other sheets want to hide with password protect,
example,
file name:- Report
Sheets:- A,B,C,D
if now using system user name is A then need to show only "A" sheet, other sheets want to be hide and the same for all.....
I developed some pivot table reports and macro'd out pdf'ing them for the users but now management want the users to be able to manipulate the data themselves !! The file is 31 sheets and I'm figuring they'll only want to see the sheets that are relevant to them so is there a way to macro it out?? Perhaps when the file opens it asks, "Who do you want to see?" Jack? Joe? or Rudy?, Month or YTD, or Both? or Everything? and it will hide the sheets that are not selected. The words "month" and "YTD" is in Cell "N1" and the individuals names are in Cell "M1".
View 6 Replies View RelatedMacros that are active in a workbook can typically be viewed by going to Tools->macro->macros. Once there anyone can see all the macros being used in the workbook.
Is there anyway to prevent the user from viewing the macros, actually I don't mind the names being displayed, but I don't want some of the macros to be launchable on demand by the user.
I have some macros stored that have the passwords to unlock the worksheets. I suppose
I can restructure the macros to possibly avoid this security issue if nothing else is available.
Is there a way of a user can add a number in a cell and this would hide a different amount of columns.
OR :
Ideally I would prefer a drop down with dates and the user could select a forward date and all the columns with dates up to that would appear. This would mean they could look as far our as required and all unwanted data would be hidden.
I see this forum and the example works perfectly in Excel 2003.. But we are using Excel 2007 now and it doesn't appear to be recognizing the user and is always refering to the "else" in the vb codes. Does this code for not work in 2007? Oh and I am refering to Post #10 on there with the attachment that will hide different sheets depending on which user is getting on the file.
View 3 Replies View RelatedI'm trying to create a macro that allows users to hide or unhide selected rows, either via toggle or userform. The macro I have looks like this, but for some reason it doesn't hide the rows:
Sub Hide_Range()
Dim UserRange As Range
DefaultRange = Selection.Address
Set UserRange = Application.InputBox _
(Prompt:="Select Range to Hide:", _
Title:="Hide Range", _
Default:=DefaultRange, _
Type:=8)
Rows.Select
Selection.EntireRow.Hidden = True
End Sub
what's wrong with my code and how I can further develop it to let the user decide whether to hide or unhide the selected rows?
I would like to hide the content of a cell so it appears blank to user. I edit excel bike tour (route) cue sheets for our bicycle club and some info is needed for formulas in calculating total distance but doesn't need to be seen by the bicycle rider.
View 5 Replies View RelatedI have nearly finished my project, but need to make the last real bit of code, then just some general tidying up.
What I want to do
- I currently have two tabs in a userform - one called 'main' and one called 'extra'.
- I want Main to always be shown to the user.
- I want Extra to be hidden (is it possible to make the tabs invisible?) and for this form to be shown only under a specific condition
I have a question on my userform (using Option Buttons):
"Did the customer ask about an extra product today?"
If the answer to this question is no - When the user hits the command button (after filling out the rest of the form), do nothing special - just return all the values to the worksheet
If the answer is yes - When the user hits the command button, I want them to be taken to the 'extra' tab. They will fill out some additional check-boxes, then hit another command box, which will return the info from both the 'main' and 'extra' sheets into the same row of the worksheet.
In brief: I want my 'extra' tab to be hidden, only to appear when 'yes' is selected, and for the results all to go back to the worksheet.
I would like to setup a macro that brings up a dialog box asking for a date in a specific column. Once that date is entered in the dialog box, the macro would then find all rows before that date (in that specfic column) and delete them.
View 9 Replies View RelatedI'm using a series of user forms for data entry to a workbook, some of them open next stage user form on completion (OK cmd button).
All that is working fine, but I'd like the initial form to close on showing the next one. I've tried adding Unload and Hide commands following the frmInsertEntry.Show (Next stage form), to no avail, but I'd like this user form to close or hide at the end of the sub.
Private Sub cmdContinueType_Click()
ActiveWorkbook.Sheets("Records").Activate 'Select starting cell in record sheet
Range("N3").Select
Do
If IsEmpty(ActiveCell) = False Then ' Search for next empty cell
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
If optDrillType = True Then
frmDrillEntry.Show
Else
frmInsertEntry.Show
End If
End Sub
Im using this formula but want to add ROI in front. =sum(t1/q1)
What is the notation?
I have a question, how do i display a number 0 in front of another number? Example, I am working with these zipcodes and there is a 000213 but it only shows up as 213 in the cell. Is there a way for it to be 000213 with out me using the tilde sign `000213?
View 4 Replies View Relatedi have to copy and paste values from an sap program over to excel spreadsheets, and I usually do about 15 at a time that end up in a column: 15 different cells. The value I am copying are ID numbers that all begin with zero and excel automatically removes the zeros at the front of each number. Is there a formula/process for preventing this.
View 2 Replies View RelatedI am trying to create a custom number format that will put a plus sign in from of the value in a cell if the value is positive.
Here is what I have been using:
+#,###;-#,###;"On Forecast"
There have been a few problems with this. Firstly, the values are have two decimals, and I have not been able to adjust it accordingly. Secondly, there are some cells that contain only a zero, and the custom format above changes the zeros to 'On Forecast. Other than these two issues, that custom format works.
Is there a formula for adding zero's in front of numbers?
Example:
If a single number is found in cell B1 add two zeros (2 would become 002)
If two numbers found in same cell B1 add one zero (34 would become 034)
I just needs to know how i can pull picture which is placed in front of any value like we pull some data through vlookup formula but here i want to know we can pull picture which is placed infront of any value.
In output sheet i have shown example of what i want and in data sheet my data is placed like that. What i want to that i enter picture id in output sheet in search option if pull's picture which is placed infront of it in Data sheet.
Click Here to see my sample File.
or [URL]
ans....>and
Good evening. I would like some helps about how to use sumif or any formula that can sum my credit. For example
code------credits
a12345------1
*b12345-----2
c12345-------1.5
*d12345-----3
The answer is 5
I would like to sum the credits only * infront of them.
I have a worksheet to keep track of products. I use an SKU column with a Unique Number to keep track of those items on the shelves.
When I started my project I never imagined that my database would grow as large as it has. I started my SKU numbers with 80000, never suspecting that I would get to 90000. I am now at 125700. Many items have been removed / sold so it only encompases only 15500 rows.
On the site that I sell these Items, the SKU's when displayed start with 100000 and go to 125700 where 80000 is next and goes to 99999? ( or the reverse depending on which tab I choose ) Not sure why this is but there is nothing I can do to change the way they do it so I must find a way to change my system. With all the 80000 - 99999 items numbered - changing them to 6 digit 125700+ numbers would be a huge undertaking so I would like to add a 0 in front of each 5 digit Number in my SKU Column. That way my items will show 080000- 125700 instead of starting in the middle.
I do keep the column my ascending order so it is currently formated as a Number. I do at times copy an paste or pull ranges items by SKU numbers to mark down or modify.
When I place a 0 manually in front of 80000- it disappears when I move from the Cell.
If I change it to a TEXT cell- it stays in place.
Excel help doesnt answer my dilemma-- nor does my book.
I see there are masks etc -- or is just text OK ? (as I stated - I do use an numbered order or range to identify groups of items at times )- if text is OK, what is the best way to add a 0 to the start of each 5 digit number other than individually ?
There are Gaps in my sequence so I cannot just replace the first cell with 080000 and pull down.
How can I use a VBA to change the font color to red for all the dates on a sheet that are within 30 days of today?
View 9 Replies View RelatedWhat I have is a sheet with Command Buttons on, and one of them when clicked launches another application which has a log in screen.
I can't for the life of me get it to bring that application log in window in front of the excel application when it runs.
I have tried various ways of sending Excel to the back once the button is clicked, but just can't get it to work.
Ideally, once clicked the new application log in window will come up in front of excel, and set focus on the Password box, is this impossible to do just from inside excel?
We are looking at
[Code] .......
I have chart object in the sheet. I wrote code that makes the cart big, but it is not on top of other things. I need to add a snippet of the code that would make it "bring to the front".
View 1 Replies View RelatedHow to remove a space in between, front & last in a excel, since i have a huge data
for example
i have in col something like this
S01 E201 = in another column i need like this S01E201
if there is space before the letter S and if there is space after the last letter 1 in need to remove the space in the excel
for more clarification
Col A
Col B
S01 E201
S01E201
S02E201
S02E201
S03E111
S03E111
I need to know how I can delete NUMBERS in front of the names....
I.E.
Colume B
12Smith
12John
13Chris
152Matt
1111Joe
12569Joe
1234Smith
I need to delete the numbers in front of the names - i have about 26thousand records like this and need to know how i can delete them.
I have a very elaborate excel file that will calculate a price for our customized product. The user enters figures into about 15 fields, and hundreds of calculations take place and give the user a unit-price for that item.
Further, this excel workbook contains 3 queries to our enterprise database that get updated on opening.
What I want is to have a front-end GUI form that the user accesses like an html page that can be viewed internally by only users withing the intranet.
The main point here is that I have very sensitive information in the workbook. The last thing I want is for it to be emailed to our competition. Protection is not an option either, because I heard it can be easily cracked.
I want my user to access the excel spreadsheet without ever getting their hands on the original.
Maybe this thing should have been written in some other software package all along, but this is what I have to deal with.
I have a number of macro's which correspond to shift numbers 1 - 23
I would like to have a drop down list on the front sheet so that the user can select the number at the end of the shift which activates the corresponding macro
I'd like to keep a progress bar userform I created in front of other windows that are opened by a module that is scanning through the data within each file. While files are opened, I want teh progress bar to stay shown at all times. Within the module opening and scanning the documents I show the userform as follows: userform1.show false
I've serached the site and found a link that supposedly explained how to do this but the site is worthless.
I have a spreadsheet that I exported from my accounting software. For some reason there are 4 columns that all begin with an apostrophe and have various lengths of white space before the wording begins.
What kind of formula can I use to get rid of the apostrophe and have the wording be left aligned within the cell with no space before or after it?
The file I am working on is attached. They are columns C, D, E and F.
I have 36 pages of names, addresses & contact info ETC that I want to print. I have a printer that offers a cover sheet in the print setup.
My list of names addresses ETC takes up two full pages of paper for each name. There are 16 columns across the sheet that contain data for each entry. I would like to print this so that I can turn the pages like an address book and see all of the data for a given set of contacts on each two page spread. So what I need to do is print the first half of the contact info on the inside of the first page and the second half on the next page and so on.
How can I set this up?