View A Worksheet With VBA
Feb 8, 2010
I've design a small little excell program that brings up a form and hides the excel workbook upon opening. By using the form the user is able to input data to a worksheet in running in the background. I've added a button on the form where I want the user to be able to open the worksheet which is password protected and view or print the data. I've already got the code to hide the workbook, protect and unprotect the sheets, I just can seem to get the code to view the one worksheet.
View 3 Replies
ADVERTISEMENT
May 11, 2009
I'm stuyding the book "Professional Excel Development" which has a Project Template and an addin with several modules and a worksheet. I can view the addin's modules but not it's worksheet - is this normal for addin's? I haven't worked with them much before.
View 2 Replies
View Related
Nov 27, 2006
I have an Excel sheet that I want to scroll up and down and I want an area in the upper right-hand corner to display static information. This information could change as more input into the sheet is performed, but it always must remain in the upper right-hand corner.
For example, let's assume the sheet has 200 rows to enter in a credit card application. There would be an area in the upper-right that would display information for some of the cells that were typed in. So as you type information, labels would display information from the form. I know that I can program the selection change event to re-position the box and labels, but if I scroll off the screen, the area does not stay there until I click on a cell on the page. I am using XL2003.
View 2 Replies
View Related
Oct 9, 2007
I've got a "Title Sheet" in which our dispatcher can come in and enter date,workorder number , Location and an item description. I am needing help automating the process for them. I need the information entered into the Title Sheet to auto insert into an existing spreadsheet depending on what location is used.
View 9 Replies
View Related
Jun 5, 2008
Ive searched for a solution around this site and it all leads to a dead end. I have a userform created in Excel, where I want to import a existing worksheet from another workbook and display it on the user form, so the user can edit it. I have tried using the Office SPreadsheet 10.0. By copy the excel file contents and pasting it into the spreadsheet cells, but PasteSpecial doesnt work so all the formating is out the door.
View 3 Replies
View Related
Sep 3, 2013
I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies
View Related
Dec 12, 2013
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies
View Related
Aug 15, 2009
if there's a way to either define what columns or rows are printable or to somehow leave columns (or rows) as visible within the print area but omitted from printing as if they were hidden.
In my CAD package I can simply elect to have certain collections of information "non-printable", is there any way I can do this with columns without having to rely on people managing to laboriously (sic) hide and unhide columns either side of printing a document.
View 8 Replies
View Related
Sep 18, 2002
In keeping with their monopoly on code, Microsoft has, of course, locked all of the included XL add-ins (the code part).
I was interested in looking at how some of these add-ins functioned, seems like it could be fairly educational.
how to unlock the modules that come with XL's add-ins?
View 9 Replies
View Related
Feb 17, 2007
i was wondering how i can get excel to hide everything except for the worksheet, as soon as it starts and then put it all back when you quit.
View 2 Replies
View Related
Aug 11, 2008
I am using some protected workbooks and cannot see the tabs at the bottom of the screen.
I have tried going to tools/options/etc
I have tried viewing full screen
If I copy the current sheet 1 and paste it into a new workbook I can then see tabs (but only sheet 1 has copied data).
View 14 Replies
View Related
Nov 11, 2008
I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well. When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window. Nothing I know of will let me view both at the same time.
If there are two open worksheets full size on the screen and I minimize one they both minimize. If I decide to close one workbook/sheet down all open workbooks/sheets close down as well. Can I view two workbooks at the same time? Can I close one down while keeping one open?
View 4 Replies
View Related
Feb 10, 2009
Ive seen on someone elses workbook the first 6 columns are fixed (always in view) then you can still scroll across but those first six columns always stay in view.
View 3 Replies
View Related
Apr 30, 2009
i was doing something in Tools -> Options -> View, & suddenly the dates in my sheet disappeared & some numbers came up, i can view the date in the formula bar, but can't be viewed in the cell, & i am also unable to do the alignment for the cell.
View 3 Replies
View Related
Oct 29, 2009
see attached WB.
Preferable solution using only Sheet Formulas only.
View 11 Replies
View Related
Dec 21, 2009
I am building an application through Excel to update specific internal website information. My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?
View 2 Replies
View Related
Feb 18, 2010
Having trouble setting VB windows views back to deafult ...
View 14 Replies
View Related
Jun 30, 2014
i'm having issues with my macro, and trying to view the string in a msgbox ,but having issues doing so:
how can i view strSourcePathname in a MSGBOX?
Code:
Sub CopyPaste()
Dim strSourcePathname As String, Report As Workbook
Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet
[Code].....
View 5 Replies
View Related
Apr 28, 2007
I work With Excel 2003
When Creating Data Sheet And Making Pivot Table
When I Make A right Click On The Pivot Sheet
The " View Code " Is Deactivated
As In the Pic
View 9 Replies
View Related
Oct 22, 2007
i am trying to use this code to view the workbook (WK) in the userform named WK
it can not reconize .spreadWK
Private Sub UserForm_Initialize()
Me.SpreadWK.Cells.Range("A1:E10").Value = ThisWorkbook.Worksheets("WK").Range("A1:E10").Value
End Sub
however this is saying that it can not reconize
.spreadWK
View 9 Replies
View Related
Nov 3, 2007
I have this data table where the totals are in the last(bottom) row.The number of rows of the table increases as new records are added to the bottom of the table. Now, the problem is , I need to have the Row that contains the Totals alwas on view no matter how big the table gets and no matter how far down/up the workshhet is scrolled.
I have tried Freeze Panes/Spliting adding new window , live shapes etc but all look dodgy and bring their own set of problems.
I have also thought about putting the Totals of the table in a row at the top of the worksheet and freezing the panes at that location but having the Totals showing at the bottom of the Table is the normal intuitive way .
View 9 Replies
View Related
Jan 7, 2008
way to keep one of my tabs visible all the time while looking at other worksheets in the same workbook, almost like a spilt screen.
View 9 Replies
View Related
Aug 16, 2006
I have 1 workbook which summerizes 3 other workbooks. My question is, is there a way that if I hide a column(s) in 1 workbook (by either using Hide or Outline), the corresponding column(s) will also automatically be hidden in the Summery workbook?
Or, is there a way that I can make the Summery Workbook only display / Link to cells that is been displayed in the source workbooks? I hope to do this dynamically, so if something is hidden by Outline or Hide in one of the workbook, the affected cells in the Summary workbook will also go in hiding.
I am hoping to do this by some magical Excel Function, if not then by VBA (I'm not that good a VBA programmer), if not even that, then maybe some free Excel Tool someone knows?
View 6 Replies
View Related
Dec 4, 2006
how can i see hidden sheets in a workbook?
View 3 Replies
View Related
Dec 5, 2006
I want to get a tree view created with the following details
NCR SUMMARY
KISHOR ASRANI
JAYDEEP SINGH
HITESH MADAN
LALIT MONGIA
ANISH BHAN
SUMIT WADHWA
VIBHOR DEWAN
SANJAY DHAR
KIRTIKAR OJHA
PANKAJ KHUSHANI
GUNJAN SACHDEV
SHUBENDU GHOSH
RON SUMMARY
SANGEETA BHATNAGAR
ATUL PAL
HARSH MALHOTRA
SALIL KHANNA
EDIT: FYI: thomach tried adding code and then quote tags to see if the indenting showed. Neither worked.
View 5 Replies
View Related
Dec 27, 2006
I have some command buttons on worksheet. I want to do next: when I am click on command button1 I am see a VBa code of command button 2 How I can do this?
View 2 Replies
View Related
Jun 15, 2007
I'm trying to create a chart in Excel that will show the liquid inventory in a sectional or end view of a storage tank. For example I have a 9,000 gal. tank with 3000 gallons of liquid, 1/3 of the circle would be shaded. Not a wedge or slice of a pie but like these charts. ttp://www.gilbarco.com/page/Inform_for_SMART_Connect
View 2 Replies
View Related
Aug 1, 2007
if it is possible (and if so how) to add a scroll bar to excel (currently using 2003). What I am attempting to acheive is to have two areas on a work sheet, the first of which contains data that is much larger than the second but both of them need to appear on the screen at the same time. If it was possible to apply a vertical scroll bar to the first range which is named this would be possible.
View 6 Replies
View Related
Dec 27, 2007
I am creating a personal expense tracking sheet for the upcoming year. I have each day of the year going down as my rows. My column headers are various expenses I expect to have, such as a phone bill and internet bill. I want a way to pick which expenses (columns) are visible. I expect this to aid in the inputting of expenses and the reviewing of expense types. I know of course, I could just click all the columns I don't want and hide them, but I'm looking for a quicker way if possible.
So, if I want to record the phone bill, or just look at the phone bill expenses alone, I could use a drop down which listed all my column headers and check which one(s) I wanted to view. I thought of like the way a pivot table option looks to pick what you want to view /shrug.
Maybe a drop down is not the way to accomplish this, and maybe my spreadsheet should be laid out differently.
View 6 Replies
View Related
May 29, 2008
I am trying to search a column of data that contains long runs of identical data (e.g., C1, C2, C3...). Without specifying which precise cell value to look for, what command or code can I use to tell the macro to "find the next cell in the column that contains the data point that is different from the current one"?
View 6 Replies
View Related
