Search results for query: *

Combo, I tried what you suggested with the VBE and it will still open the workbook and stop running. Skip, The shift key was removed from the macro shortcut but now I am running into problems of users needing to bold or copy information and macros running instead of ctrl-c copying etc. We did...

Yes. When it is stepped it works. I changed the macro keyboard shortcuts to have no shift and the code runs as expected. It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid. Therefore I have come to the...

The main workbook holds all the code and runs it, the other workbook simply is a log of data entry errors. So as the macro in the main workbook runs, it opens the log but when the log is opened the code simply stops. There are no error warnings, no pop ups, nothing. I found out from various web...

Greetings one and all, This one has been bothering me for awhile and Microsoft hasn't been any help. I have code to open a workbook, however due to the known bug in Excel sometimes the code simply stops when the workbook is opened. Microsofts patch (below) deals with the shift key and isn't...

Thanks Skip! It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid. Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug...

This is a new one for me and something that was just discovered with our main workbook. Worksheets will sometimes get copied over to the main workbook. However this can create names in the name manager and recording a macro didn't offer any light on how to remove all the names. Since I don't...

Thanks to both of you. Skip that gave me what I needed. It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid. Therefore I have come to the logical conclusion that the only way to have a properly functioning...

I am trying to set up a page so that when it is printed the print area is preset. So far I have found ways to print the selection and toyed with Workbook_BeforePrint, but have not found a way to preset the selection area for the user. Given the amount of printing, setting the print area is...

I am not following what you want to do. Are you trying to underline or bold text or are you trying to copy it somewhere? And yes, text can be converted to HTML, just don't remember how at the moment. It has taken me a while to make sense of what I hear at work involving computers. There is...

Found this link http://stackoverflow.com/questions/18601744/excel-headers-footers-wont-change-via-vba-unless-blank Haven't yet been able to test and see if that solves the problem. It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and...

You are correct. The footer is created for each sheet because it holds specific information for that sheet. CB_PANEL_NAME references which two sheets the footer is identifying JOB_NUMBER is the number the shop and engineers use TEMP_NMBR holds the specific info for the job number and...

I don't know the problem has been solved long term, however I was able to get the pages to print with the footers showing properly. If possible, I would like to find or write code that will stop this from happening again. It has taken me a while to make sense of what I hear at work involving...

Thanks Combo. That didn't solve the problem directly but it made a huge leap forward. I ended up having to recreate my sheets with the correct footers and then printing them without going into print preview. It has taken me a while to make sense of what I hear at work involving computers...

Private Sub CB_Formatting() On Error GoTo Error_Handler 100: Application.StatusBar = "Running Panel_Master. Sub CB_Formatting" ' Footer for worksheet. Must Remain intact. 200: With Sheets(CB_PANEL_NAME).PageSetup 300: .LeftFooter = _ "&16Model: " &...

The other forum post was aimed at possible worksheet issues targeting printing, this post was aimed at more behind the scenes things that would be more coding oriented. It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions...

Are there any known coding reasons why a footer in Excel would not update properly for printing? The code for the footers is created in a separate macro, and the workbook can be closed and re-opened and the footers will show up on print preview and print correctly for the first few. Up to ten...

I have an Excel workbook that the footers are acting goofy when printing. When I first open the workbook the footers will show up on the print preview and print correctly for a handful of sheets, however if I select several sheets to print the footer doesn't up date properly and will print with...

I also have been trying this in the loop Do While fileName <> "" j = 1 Workbooks.Open (directory & fileName) For Each sheet In Workbooks(fileName).Worksheets If Workbooks(fileName).Worksheets(j).Name = "IOList Base" Then GoTo 1100 ' If the sheet starts with IO we have gone to...

I have to collect the information in Columns A, D (earlier mistake to say C) and F, I to add to a default list, then it will be sort to remove duplicates and used to update our error checking with data entry. A and D are paired as well as F and I. These columns will create a library of past...

Hey Skip, I was able to make this work. Option Explicit Public directory As String Public fileName As String Public sheet As Worksheet Public i As Integer Public j As Integer Public X As Integer Sub Extract() On Error GoTo Error_Handler 'Application.ScreenUpdating = False directory =...