A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
executing code when a module opens by max
Hi, Is there a method to automatically execute a block of code when either: 1) a project is opened in the VBA editor, or 2) a module within a project is...
July 8th 03 07:37 PM
by max Go to last post
0 348
Unprotect method run-time error by Rohit Thomas
I should have been more specific. The code works fine with XL2K on a Win98 or WinNT machine, but does not work using XL97 on a Win98 or WinNT machine. I had...
July 8th 03 07:32 PM
by Rohit Thomas Go to last post
0 493
Macro Using Named Cell by Dan E[_2_]
JAD Application.Goto Range("RangeName") or if your range is on another sheet Application.Goto ThisWorkbook.Worksheets("SheetName").Range("RangeName") Change...
July 8th 03 07:29 PM
by Dan E[_2_] Go to last post
0 380
SUMIF function by TIm McPhillips
Does anyone know if you can use the sumif function and reference another cell for the criteria. In other words, can I have the criteria something along the...
July 8th 03 07:09 PM
by TIm McPhillips Go to last post
0 312
Excel: Deleting Macros and Functions by Earle
Sir Chip, Thank you for the rapid response. Regreatfully, when I visit the URL you provided all I get is a nice header and... <table border="0" wid I'll...
July 8th 03 06:47 PM
by Rita Nikas [MSFT] Go to last post
1 367
Exporting Data..... by Al Mackay
Tom Thanks so much for what you've done here. It worked brilliantly. However, the requirement has now slightly changed (I should have foreseen that...
July 8th 03 06:46 PM
by Al Mackay Go to last post
0 358
For Next Looping (custom variables) by [email protected]
I often use For Next Loops to loop through routines: For X = 1 to 10 I know that you can also step through the loop based on a constraint: For X = 1 to...
July 8th 03 06:30 PM
by Mark Bigelow Go to last post
1 365
Deactive Copy and Paste by Seth[_3_]
You can also protect the worksheet(s) so that pasting is not possible, and if the protection is such that the user cannot select any cells (i.e., they cannot...
July 8th 03 06:20 PM
by Seth[_3_] Go to last post
0 351
Digital Certificate creation error using makecert by John[_35_]
I found this message on how to solve the problem where one cannot create a digital signature using makecert. "I used makecert.exe to create a new certificate...
July 8th 03 06:16 PM
by John[_35_] Go to last post
0 469
Inputbox method using type:=8 - How to Cancel? by Jim Cone
Joe, I have been happier using the InputBox function instead of the InputBox method. It returns a string and if cancel is clicked it returns a zero length...
July 8th 03 06:15 PM
by Jim Cone Go to last post
0 458
Undo, Redo, Repeat and Validation by John[_35_]
I have some cells in my worksheet that have data validation on them. The problem is, if data is pasted on them from cells that do not have validation, the...
July 8th 03 05:58 PM
by John[_35_] Go to last post
0 408
Device I/O Error by Seth[_3_]
While doing some simple programming using the ADO object model to query an Excel workbook I keep getting a message box in the VBE that says "Device I/O...
July 8th 03 05:58 PM
by Seth[_3_] Go to last post
0 341
Excel ADO Connectstring parameters by Jeff[_16_]
Does anyone know what parameters to use in an excel DSN statement when connecting to Sybase to populate the Host and Application values? This spreadsheet...
July 8th 03 05:44 PM
by Jeff[_16_] Go to last post
0 354
Hidden sheets becoming visible after saving from Browser by Carole
An excel workbook with multiple sheets is saved in 2000 and published to the browser with some of the sheets hidden. The report is run in the browser, but...
July 8th 03 05:19 PM
by Carole Go to last post
0 319
dates in userforms by Ben G
Thank you so much, you saved my sanity! Ben
July 8th 03 04:55 PM
by Ben G Go to last post
0 322
Auto Fill Program needed to get maps from internet onto excel by Tricia[_2_]
Ok, first let me tell you that this isn't something I need so that I can register a thousand times to websites or whatever that problem they have with...
July 8th 03 04:25 PM
by Chong Moua Go to last post
1 337
Excel Addins by AA[_2_]
Can an Excel Addin, on a network volume, be used concurrently by multiple users?
July 8th 03 04:10 PM
by Charles Williams Go to last post
2 321
Can we write VBA code to set all column/row's size back to default size? by Charles Williams
You can use the worksheet standaheight and standardwidth properties ActiveSheet.Rows.EntireRow.RowHeight =...
July 8th 03 03:56 PM
by Charles Williams Go to last post
0 411
dates in userforms by Ben Guenther
Thank you so much! I was starting to loose my mind! Your solotion works great. Thanks again, Ben *** Sent via Developersdex http://www.developersdex.com...
July 8th 03 03:44 PM
by Ben Guenther Go to last post
0 375
Check mark boxes in Excel 2002 by Dan E[_2_]
Nicole, If you have the control toolbox open make sure that you are out of design mode. The button looks like a triange, ruler and pencil (in excel 2000). If...
July 8th 03 03:41 PM
by Dan E[_2_] Go to last post
0 403
Post New Thread

Display Options
Showing threads 173981 to 174000 of 174039
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.