Over 1 million tech questions and answers.

8gadgetpack - how to hide/unhide from command line?

Q: 8gadgetpack - how to hide/unhide from command line?

Hi!

I want to no how I can hide gadgets from the command line.

I'm constantly frustrated by the fact that the gadgets layout is destroyed when I rotate my screen. So I set a scheduled task to unpack and overwrite the ini file for the gadgets.
But it doesn't work reliably (nothing does with the pathetic task Sheduler). The task doesn't run on time (or doesn't run at all) and such the layout is still broken. So I was thinking I could hide it via command line, restore the ini, then show them again. (With three tasks with a delay, because the task scheduler is garbage and it wont work otherwise, if it'll work at all.)

Read other answers
RELEVANCY SCORE 200
Preferred Solution: 8gadgetpack - how to hide/unhide from command line?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 92.4

I want to hide this. I'm running a python progam (if that matters) and it always has that open on my taskbar. I want to hide it. I don't care where it goes or how much time it takes, I just want to hide it. So I never have to deal with it. Maybe make it a system process or something? I don't know.
 

Read other answers
RELEVANCY SCORE 78

os : windows 7 sp 1

VLC media player version 2.2.0

When open vlc media player an additional vlc window(command line interface) opening ,

how to hide that command line interface in VLC

can't able to close command line interface window, when i did total vlc closing ???

A:how to hide VLC media player command line interface

Hi have you tried going to the vlc program file in all programs and resetting the preferences

Read other 2 answers
RELEVANCY SCORE 66.4

I have my taskbar set to hide. When I move my mouse to the edge of the screen, it will pop out sometimes and sometimes it is necessary for me to size-down the program that fills the screen, move the mouse to the edge of the screen again and it pops out but goes behind the program that partially fills the screen.

This has me believing the taskbar pops out all the time but behind whatever maximized program is on the screen. This behavior is not restricted to one maximized program and is sporadic.

See screen shot.
 

A:TaskBar set to hide, will not unhide

Read other 7 answers
RELEVANCY SCORE 66.4

Hi All,

Is there any shortcut key/command for hiding and unhiding folders in Vista?

Regds..

A:Hide/Unhide Folder

Welcome Unirock

Hope that this is what you are looking for.

Use Keyboard Shortcut To Show/Hide Hidden Files & Folders

I suggest that you make a system restore point before trying.

Hope that it works.

Read other 3 answers
RELEVANCY SCORE 66

Anybody know the command to copy a disk? Like Linux = cp /dev/sda /dev/sdb , or dd xyz -> xyx

What's the Windows command line syntax for this copy task?
 

A:Command line to clone disk? COMMAND line; NOT 3rd party app.

No. Don't believe that is built in. The latest Windows versions have imaging software built in with a GUI.

Or, DD For Windows

Free system imaging/backup software:

Macrium Reflect (Free)
O&O Disk Image Express
Comodo Time Machine
Clonezilla Live (A bootable CD of Debian with Clonezilla.)
Paragon Backup & Recovery
Drive Image XML
PING (Partimage is not Ghost)
Partition Saving
Clonezilla
 

Read other 3 answers
RELEVANCY SCORE 65.6

Hello

Yesterday I created a code that hides/unhides rows when checkbox is clickedand goes something like this:

Rows("22:24").EntireRow.Hidden = Not Rows("22:24").EntireRow.Hidden

But now i only want to hide/unhide specified cells. So how can i modify the code above to do this or do I need some new code.

Thanks for help
 

A:macro to hide/unhide cells

"hide/unhide specified cells" - I take it, you mean rows, not cells.

What's your criteria for hiding/unhiding the row? All you need to do is loop through each row in your criteria column, and then program this in as your hide/unhide criteria.

Pseudo Code:

Code:


Sub hideAndUnhide()
[INDENT]For Each Cell In Range("A1",Range("A1").End(xlDown))
[INDENT]If(Cell.Value = 1) Then
[INDENT]Rows(Cell.Row).EntireRow.Hidden = True [/INDENT]
Else
[INDENT]Rows(Cell.Row).EntireRow.Hidden = False[/INDENT]
End If[/INDENT]
Next Cell
[/INDENT]
End Sub

If you let me know your data layout, and your criteria, I should be able to make a proper version for you. Even better would be to post your excel sheet with dummy data (remove any sensitive data).
 

Read other 2 answers
RELEVANCY SCORE 65.6

Hi Guys

I used unhide.exe after a virus I had... it done the trick.
However, is there an easy way to re-hide all the system files that were hidden before?

Thanks for any help.

A:How to re-hide system folders after using unhide.exe?

Hello, depending on your Operating System you should just need to reverse the change that was made. Look at your system in this guide and put the checkmark back in the box.How to see hidden files in Windows

Read other 7 answers
RELEVANCY SCORE 65.6

Hi,

I have a button that when clicked calls a fucntion "customtoolbar.hidden = true" to hide the custom toolbar. When I wish to unhide the toolbar, I go to view > toolbars, however I noticed that the customtoolbar is still checked and when I click on it the toolbar does not appear!

Any ideas why?

Thank you

Regards

Chris

A:[SOLVED] Hide/Unhide toolbar

Hi,

Welcome to TSF!!

If I am understanding you correctly you are wanting to make your toolbars appear and then re-appear. The simple answer the that question is to use the F11 key. That will make all your tool and task bars disappear. Then when you want them back just hit F11 again. I wouldn't bother with all this changing the about:config if you don't have to.

Cheers!

Read other 2 answers
RELEVANCY SCORE 65.6

with regards activex checkboxes in excel, i know you can hide or unhide the said boxes by going to properties and changing the visable section from true to false, can this also be done by using code so if a visable checkbox on the worksheet is ticked this will then display other hidden checkboxes
your help is appreciated
thanks
 

A:Solved: hide unhide excel

Yes, that can be acieved. The best thing to do is attach a copy of your workbook (replace sensitive data with dummy data), so that we all can take a look at your worksheet(s) structure.
 

Read other 1 answers
RELEVANCY SCORE 65.6

I have two issues that I am banging my head over.

1) I have a page with 4 tables. The top 2 tables each have a link that when clicked will bring up one of the bottom two tables. I have this working now where the bottom tables are hidden until the link is clicked then becomes visible.

The problem is the space is still being taken up by the other hidden table. So if I click the second link, there is this huge gap and then the other table is visible. Any idea on how to not have the gap? I tried using "document.write" but the way I wrote it screwed up the layout.
2) Problem two is similar. I have a form select, that when option 2 is selected I would like to make a table visible. I tried using the same code as the one above with an anchor tag on the second select but it did not work. I then changed it to onSelect and still nothing. Any ideas on how to make a selection make a table visible?

Thanks in advance.
 

A:Hide/Unhide tables in pages

Read other 8 answers
RELEVANCY SCORE 65.2

I hid columns D through AN on a spreadsheet. I then realized that I needed some information from column D. Is there a way to unhide one column from a group that you've hid Right now I have to unhide one column at a time to get back to the one that I need. Any help would be appreciated
 

A:Solved: An Excel Hide/Unhide Question

Press F5 -- type D1 -- press Enter.

Then Format > Column > Unhide.
 

Read other 2 answers
RELEVANCY SCORE 65.2

i am using a userform with a listbox that a user chooses a value, that value is then placed in sheet 15 at cell 29, what i would like is if the value chosen is 6 then rows c6 - c25 in sheet 15 are unhidden otherwise they remain hidden, i have managed to do this before using checkboxes but not via a userform, any ideas for code please
 

A:Solved: excel hide/unhide on cell value

You need to trigger a macro which can be called from the form.

When a value is chosen, the macro triggered will be something like

To hide:
Range(Cells(6,1),Cells(25,1)).entirerow.Hidden = true

To Unhide:
Range(Cells(6, 1), Cells(25, 1)).EntireRow.Hidden = False
 

Read other 2 answers
RELEVANCY SCORE 65.2

I have my W7 set not to show hidden files and folders.

To show them I go through the usual process , open Windows Explorer then click on the tabs Tools > Folder Options > View and then change to "Show hidden files ...." Naturally have to go through this process again to hide.

Is there a simple keyboard shortcut or some way that I can easily toggle the hiding and unhiding of all folders and files. Not just on individual folders , but have all folders and files that are set to be hidden , to hide and unhide in a simple keystroke.

A:Shortcut to hide and unhide folders and files

Is this what you're looking for?

Read other 8 answers
RELEVANCY SCORE 65.2

First Hi,
Second, I'm not sure this is in the right section, my apologize if I made it wrong.

Third, my weird problem,
In Windows Explorer, I have set the option to see hidden files and system files and I do see them. The problem arise when I try to "unhide" a file. I right-click the file and choose "Properties", bottom I see Hide option box, it is checked but also greyed out so I can't "uncheck" it.

Anyone knows why and how can I fix this?

Thanks

A:Hide/Unhide option unavailable in explorer

I have found part of the solution.

Going through command line I found out that the files were marked as System along with Hidden. I used the command Attrib to remove both and now I can hide/unhide the file. Is there anyway to unflag "System" from Windows Explorer. I don't mind doing it from the command line but would be more "practical" from Windows Explorer.

Thanks

Read other 9 answers
RELEVANCY SCORE 65.2

I am building an excel model and want to link a macro to the "calculate" button based on the above check boxes. If the boxes are selected, the relevant graphs would need to unhide and show and then hide as the boxes are deselected again.

I've attached a screen shot of what I'm working on.

I would appreciate any help possible on how to write the code for this macro.

Many thanks
 

A:Excel 07 - Macro to hide/unhide rows

Welcome to the board.

Screenshots saved as bitmaps are huge. Convert them to (e.g.) jpgs, then you can upload without zipping.

Re this part of your post specifically:

Macro to hide/unhide rows

, one "basic" answer is:

Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Rows("11:20").EntireRow.Hidden = False
Else
Rows("11:20").EntireRow.Hidden = True
End If
End Sub

Do you actually have ten charts, or is it far more in reality?
 

Read other 2 answers
RELEVANCY SCORE 65.2

Hello,
I am looking for a way to hide and unhide specific files/folders of my choosing. I imagine this can be done via a method or third party program that creates two options in the right-click context menu:
1) Hide selected files/folders
2) Unhide all files/folders

I am open to other suggestions or ways in which this can be done, of course.

Thanks!

A:How do I hide/unhide specific files of my choosing?

Hello Mark,

You could use the tutorial below to actually hide or unhide a specific file or folder.File and Folder - Hide or Unhide
However, when you choose to show hidden files, it shows all hidden files and not just select specific ones. If you like, you could use the tutorial below to be able to toggle showing or not showing hidden files in the context menu.Show - Hide Hidden Files - Add to Context Menu
Hope this helps,
Shawn

Read other 9 answers
RELEVANCY SCORE 64.4

Hey all

New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information.

Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form pulling information over from the cost est. form. What I would like to do is on the proposal form if rows c13:c277 are blank (no data pulled from the cost est. sheet) they will hide. But when I add data (a number) into the cost est. form the proposal form pulls that and unhides that row.

I've tried all kinds of VBA code and none seem to do what I want. I can get the rows to hide but then not unhide. I don't have code to show because I have deleted it when it didn't work. Any help would be greatly appreciated.
 

Read other answers
RELEVANCY SCORE 64.4

Hey all

New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information.

Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form pulling information over from the cost est. form. What I would like to do is on the proposal form if rows c13:c277 are blank (no data pulled from the cost est. sheet) they will hide. But when I add data (a number) into the cost est. form the proposal form pulls that and unhides that row.

I've tried all kinds of VBA code and none seem to do what I want. I can get the rows to hide but then not unhide. I don't have code to show because I have deleted it when it didn't work. Any help would be greatly appreciated.
 

Read other answers
RELEVANCY SCORE 64.4

I know about right-clicking the Desktop | Properties |Arrange Icons By | Show Desktop Icons. But I do this so many times during the day that I would like a hotkey for this. Preferably one key, not a key sequence.

Do you know of a way to do what I want?

Thanks,
Cindy

A:[SOLVED] hide and unhide desktop icons hotkey?

Hi Cindy,

My boyfriend needed a solution like what you described and he ended up buying this nifty tool. He loves it:

http://www.softwarecandy.com/shop/downloads/hide-desktop-icons

I hope this helps.

Maria

Read other 8 answers
RELEVANCY SCORE 64.4

I know about right-clicking the Desktop > View > Show Desktop Icons.

But now I am looking for a HOTKEY to simply hide or show the desktop icons.

I found some instructions on google that seem to work for windows xp but they don't work for me on windows 7.

Do you know of a way to accomplish what I want?
 

A:Solved: hide and unhide desktop icons hotkey?

Read other 7 answers
RELEVANCY SCORE 64.4

Alright, here's what I got going on:

I want to be able to have a completely clear desktop, void of icons and start toolbar with a hot key. However, I would like to be able have access to the start toolbar and able to have desktop icons available to me. This is where the hot key would come into play: the ability to hide/unhide both sets (icons and toolbar) simultaneously. Does anyone know of a program or registry hack that would accomplish this?

Thanks.

A:Hide/Unhide Start toolbar & Desktop icons

what is a start toolbar?

there is this for the icons :

clik here

Read other 2 answers
RELEVANCY SCORE 64.4

Hi! Good Day!

I cant find ways to automatically hide & unhide row depending in G14, G15 & G17. I dont know if it is applicable to Excel. Even if the solution is in other programming language, then its ok to me.

If G14=4 & G15=3 & G17=2 then hide row 28 to 29 & row 36 to 38 & row 43 to 46

I have attach a file for reference.

Thank you so much!
 

A:Auto Hide & Unhide Rows per data input

This is on the assumption that your rows are not fixed and that your code is AB#.
 

Read other 1 answers
RELEVANCY SCORE 64.4

Hello to evrebody,
I have look into the answers and the solutions about "hide/unhide rows based on the cell data" but i am not abble to understand how its work and apply to my sheet.
On theattached sheet i explain what im looking for.
Pleaseo play it and hope to help me and give a solution please.
Thanks in advance.
Jose
 

Read other answers
RELEVANCY SCORE 63.6

I will eventually want this to work on all worksheets in the workbook as their data may change as the "linked tables" are refreshed. The linked tables are from Access.

What I want to do is look in column Q to see if the result of the calculation in that cell is 0. If so, I want the row hidden. I don't want to hide empty rows, just the one where the calculation =0. If the data in the workbook, i.e. the linked tables are updated, then I want any rows that have changed from 0 to another value to then become unhidden.

I have been searching for VBA code to auto hide/unhide rows in Excel 2007 based on the value in a specific column. I found the following code, but can't seem to get it to work quite right. I changed some of the criteria to fit my worksheet. The problem is that it hides all rows that are empty even though I changed the criteria from "" to 0. Also, this does not unhide rows that may refresh with a value.

I would really appreciate some guidance. My Access and Excel skills are pretty good, but when it comes to incorporating VBA into the mix, I get a little lost.

Sub HideEmptyRows()
'This macro hides all of the rows which are empty, for printing.
'created by Geoff Faulkner 12-29-2004

'Declare variables
Dim intStartRow
Dim intEndRow
Dim intTargetColumn
Dim intCounter

'set default values
intStartRow = 6
intEndRow = 2000
intTargetColumn = 17

'cycle through each row in the range
For intCounter = intStartRow To ... Read more

A:Solved: Excel 2007 Auto Hide/Unhide Rows

Read other 6 answers
RELEVANCY SCORE 63.6

I built my pivot table now I would like to be able to hide/unhide certain elements in my pivot table. How do I do this? is there a way to toggle on/off certain elements I want to appear without having to reselect elements for the table?
 

Read other answers
RELEVANCY SCORE 63.6

Hello to all,

I'm new to VBA in general and I'm in need of help in making my project works. I'm currently working on hidden in-sheet menu (rows 2 to 6) that could by unhidden by double-clicking on the cell "D1" and hidden again by double-clicking on "A6". I want to use that menu in every sheets.

I would really appreciate any inputs on this matter. Feel free to view my spreadsheet for a better idea.

Thanks in advance!
 

Read other answers
RELEVANCY SCORE 63.6

Is there a way in Excel (I'm running Excel 2010, but have access to older versions) to hide/unhide cells based on hyperlinks or defined areas? I've hyperlinked so that we could go to specific parts of the document, but that does me little good because we have to hide them or the doc gets to big. Is there a way to have the hyperlink (or the cell hyperlinked) unhide the area? I've attached the document (removed all company info, but the lay out is there) so that you can see what I'm referring to.

I've thought macros, but I'm not sure how to go about it... I did define each area for the hyperlink, so would that be the route to go?
 

A:Excel - Hide/unhide based on defined cells/hyperlinks?

Read other 6 answers
RELEVANCY SCORE 63.2

Hi there! I'm new to using these forums, but have spent some time scouring them from time to time to look for simple solutions to any excel/VBA problems I'm having. I consider myself relatively intermediate to advanced in Excel as far as formulas and spreadsheet creation goes, however VBA is foreign to me, and an area I'd love to learn. If any of you have recommendations on a good resource to begin learning VBA, please send it my way. And now....onto my macro question.

I've got a workbook with many tabs, and one or two input tabs feed information into another summary tab using various lookup and index formulas. There are any where from 40 to 80 rows to be qualified depending on the specific summary sheet (therefore I will likely need the macro to reference only the active sheet as it needs to work the same way on different sheets independent of each other). What I would like to do is if the result of the formula in column A of the summary sheet is "----------" (starts at A7) then I would like to hide that row, and if the data is changed on the input tab to result in anything other than the qualifying "----------", for that row to be unhidden. If this can be done dynamically that'd be great, however, if a button needs to be put into the spreadsheet to execute the macro, that will be fine too.

Thanks so much in advance for your help, and I promise I'll do my best to begin learning VBA so I can help contribute in return!
 

A:Macro to Hide/Unhide Rows Based on Results in Column Equation

HI,

Here is a code that may help you. You can copy and paste it too a module.
When you copy it to a module you can assign a "Short" cut key to activate the code.
To do this you select "Tool", "Macro" and when you see the name of the macro you want to run you can select it and then select "Options" and assign the short cut key. You will be able to use the short cut key on any active sheet.
Code:

Sub Hide_Row()
Application.ScreenUpdating = False
Dim Mysh As Worksheet
Dim cel As Range
Set Mysh = ActiveSheet
For Each cel In Mysh.Range("A1:A" & Mysh.Range("A65536").End(xlUp).Row)
If Not (Mysh.Cells(cel.Row, 1).Value Like "--*") Then
Mysh.Cells(cel.Row, 1).EntireRow.Hidden = False
Else
Mysh.Cells(cel.Row, 1).EntireRow.Hidden = True
End If
Next
End Sub
 

Read other 2 answers
RELEVANCY SCORE 63.2

Good day everyone.
Basically I need to have a formula in excel that includes auto hide and unhide of rows based on the result value. Attached is my sample exercise for quick reference. In this exercise, I want to hide automatically the rows under "REPORT OUTPUT" that contains "0" ZERO value. Basic guide: Once you enter value (from 1 to 5) in cell D3, report output will automatically calculate...... The missing condition in the formula is to automatically hide ZERO value.... Please help.
Thanks in advance.
 

A:Solved: Formula with auto hide and unhide rows based on result value

Read other 16 answers
RELEVANCY SCORE 62.4

Dear Brink,

Is it possible to disable/re-enable or hide/unhide Start Menu in Windows Vista via registry, using VB6 or at least disable/re-enable all items in (shortcuts and everyrthing else in Start Menu) in order to exclude starting of ANY program via contents of Start menu in Vista while my own application is active?

Could it be possible to disable/re-enable "Windows" key or any combinations of keys such as "Windows" + "Esc" via registry, using VB6?

Thanks in advance for your help.

vnaz235

A:Disable/re-enable or hide/unhide Start Menu in Windows Vista via registry, using VB6

Hello Vnaz235, and welcome to Vista Forums.

I'm not sure what you mean by the first question. Did you want to stop a startup program from running?


This tutorial will show you how to enable/disable all Windows Key keyboard shortcuts.

Windows HotKeys

Hope this helps,
Shawn

Read other 5 answers
RELEVANCY SCORE 59.6

Somehow the line that you put web sites -- after the http --has disappeared. I'm sure that there's a simple way to get it back but I'm new to WIN XP. Can someone help.
 

A:Lost command line -- line with site addresses WinXP

I think you are talking about the address bar in a web browser???

You did not mention what browser you are using. For Internet Explorer 6, right click in any other visible menu bar and then make sure that "Address Bar" is checked in the box that pops up. This may work for other versions of Internet Explorer.
 

Read other 3 answers
RELEVANCY SCORE 59.2

Hi!

I need before calling one program insert text into clipboard.
I can do batch for this, but really don't know any command to send any text to clipboard.
Exist any command or method how to do it?

Thank you for all.
Miro36

Read other answers
RELEVANCY SCORE 58.8

Hello,

I'm trying to split a .flv file by using flvparse, which is a Windows-only, command-line interface tool. I did get through to the directory by following instructions posted on another forum, however, command prompt doesn't seem to recognize the the .exe file. I'm an absolute novice at this, any help would be really appreciated!

Attaching a CP s/s, and here are the instructions I'm trying to follow (copy pasted from the forum)

FLVPARSER

For trimming the beginning and/or ending of videos, you can use FLVParser (http://dev2.avacast.com/FLVparser.zip ).
FLVParser is a Windows-only, command-line interface tool. After you unzip it, move its folder to C:\ for ease of use. Also for ease of use, copy/move the .flv file you wish to edit into the FLVParse folder.
To make edits, you need to know the in and out points where you want the edits. Use FLVPlayer to find these points. FLVPLayer only lists times in total number of seconds, not HH:MM:SS, but don't worry, FLVParser can handle that. In the FLVParse directory create a new blank text file called: CuePointFile.dat
This is the file FLVParser uses to edit from. Open it in NotePad, and enter the in point and out point, separated by a single blank space, like so: 2525 5150
Save, and close the file. Open up the command line interface and go to the FLVParse directory: cd C:\FLVParse
In the command line, enter this to edit the flv:
flvparse.exe FileToSplit.flv CuePointFile.dat
Your file will be split into ... Read more

A:Command Prompt doesnt seem to recognize the command line!!

You are using the basic cmd, try in elevated mode
Elevated Command Prompt - Windows 7 Forums

However looking at you screen shot, you may have to check the command over carefully. There does appear to be an error in the command. With my eyes, it is difficult at times to pick out the subtle shades of difference.

Read other 1 answers
RELEVANCY SCORE 58.8

Hi everyone, what is the commmand for command prompt to stop a process? What i would like to do is make a shortcut to stop the KBD.exe process. The reason for that is when someone in my family puts a disk in, plays a game, and sometimes when they take the disk out it complains about there being no disk in the drive. The only way to shut it up is to end the process in the task manager and click cancel on the window. This way is a little to complicated for some of the memebers of my family and i would like to be able to just create a shortcut for it.

A:Whats the command line command to stop a process?

Quote:





Originally Posted by djw2009913


Hi everyone, what is the commmand for command prompt to stop a process? What i would like to do is make a shortcut to stop the KBD.exe process. The reason for that is when someone in my family puts a disk in, plays a game, and sometimes when they take the disk out it complains about there being no disk in the drive. The only way to shut it up is to end the process in the task manager and click cancel on the window. This way is a little to complicated for some of the memebers of my family and i would like to be able to just create a shortcut for it.




Click on Start, then run
type in cmd to get to command prompt
type in taskkill /f kbd.exe

The forward slash /f forces it to kill the process.
Here is link for some examples

http://www.tech-recipes.com/windows_tips446.html

Read other 2 answers
RELEVANCY SCORE 57.6

Hello all, what command would I run to set JUST the secondary DNS on clients machine, and nothing else? I appreciate the help! :)

A:[SOLVED] What is the command line command to set up secondary DNS?

:) Anyone have any idea? Maybe this can be moved to the 2003 server forum?

Read other 3 answers
RELEVANCY SCORE 57.2

Hi

I am looking for help on VBA to unhide a specific sheet to enable the macro to run, then once complete to rehide the sheet.

Code I have so far is as follows:

Application.ScreenUpdating = False
Sheets("IRIS_JNL_W2.1").Select
Range("A2:C500").Delete

Sheets("IRIS_JNL_W2.1").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
Range("B1").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
Range("C1").Select
ActiveCell.FormulaR1C1 = "=""W2-1 - Jnl No.""&'W2-1'!R[9]C[-2]"
Range("A2").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
Range("B2").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
Range("C2").Select
ActiveCell.FormulaR1C1 = _
"=IF('W2-1'!R[9]C[-2]="""",IRIS_JNL_W2.1!R[-1]C,""W2.1 - Jnl No.""&'W2-1'!R[9]C[-2])"
Range("A2:C2").Select
Selection.AutoFill Destination:=Range("A2:C500"), Type:=xlFillDefault
Range("A2:C500").Select
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "A").Value) = "0" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
Columns("A:C").Select
Selection.Copy
Selection.PasteSpecia... Read more

A:Solved: Unhide sheet, to run macro, then hide sheet

to hide
worksheets ("IRIS_JNL_W2.1").Visible=False

to show
worksheets ("IRIS_JNL_W2.1").Visible=True

Peace be upon you
 

Read other 1 answers
RELEVANCY SCORE 55.6

I need some help, but probably don't have a full grasp on the problem, so don't really know how to ask for help. I will describe what I have and hopefully, it will help to describe what I want to accomplish.

I have a Linksys router with DD-WRT installed. I am able to SSH/Telnet into the router. I would like to be able to reboot or shutdown my computer remotely from the command line during a Putty/SSH session.

Here is how I make the session connection: In Putty, I enter
the static IP address and port (default is 22) under "Session".
Under "SSH > Tunnels" I enter the "source port" (again, 22)
and "Destination" (ex - 192.168.0.5:3389), then hit "Add", then "Open"

This opens a command line, where I enter "user" and "pwd"
(the defaults are root and admin). I am now connected to my
router and I can use Remote Desktop to get control over my
remote computer (using XP Pro).

My question is: While at the command prompt, is there a
command to reboot or shutdown my remote computer? Is there a list
of other commands that are available here?

BTW, at the command prompt, I can start my remote computer (Wake on LAN) by typing the following command:
/usr/sbin/wol -i 192.168.0.5 MA:CAD:RE:SS:44
(where the last portion is the MAC address)
 

Read other answers
RELEVANCY SCORE 55.6

I came across this (hopefully) helpful article about command line basics.

Speaking UNIX: Command the power of the command line

Learn the basics of the UNIX shell and discover how you can use the command line to combine a finite set of UNIX utilities into data transforms.
 

A:Command the power of the command line

Good stuff, but then there's something wrong with his verbatim copy of a directory... You should add the p option to the tar extraction command, in order to preserve file attributes (ctime, mtime, atime, owner, group) - ie, tar xpvf and not tar xvf.

I use this regularly in order to make verbatim copies of a directory:

(cd /path/to/src/dir && tar cf - .)|(cd /path/to/dst/dir && tar xpvf -)
 

Read other 3 answers
RELEVANCY SCORE 55.6

I want to create a setup whereas a command line command can be run from any directory/folder, without having to be in the directory/folder whereas the command line command resides ?

A:Executing command line command anywhere ?

Add the directory the cmd or bat files resides in to the PATH environment variable.





Quote:
To check or modify the system PATH environment variable, do the following:

XP: Right clock on My Computer
Vista, 7: Right click on Computer
Windows 8, 10: Right click on This PC

Select Properties

Vista, 7, 8, 10: Click on Advanced System Properties on the left

On the Advanced tab, click on Environment Variables
Under System Variables, scroll down to Path
Select it then click Edit

An easy way to look at all of it is to right click on the highlighted Variable Value field and select copy, then start Notepad and paste the data into there. That way you can easily look at all of it.

It's also a lot easier to make changes in Notepad then copy and paste the changed data back into the Path Variable Value field.

Click Ok as needed to exit when done

Read other 4 answers
RELEVANCY SCORE 55.6

I came across this (hopefully) helpful article about command line basics.

Speaking UNIX: Command the power of the command line

Learn the basics of the UNIX shell and discover how you can use the command line to combine a finite set of UNIX utilities into data transforms.
 

A:Command the power of the command line

Good stuff, but then there's something wrong with his verbatim copy of a directory... You should add the p option to the tar extraction command, in order to preserve file attributes (ctime, mtime, atime, owner, group) - ie, tar xpvf and not tar xvf.

I use this regularly in order to make verbatim copies of a directory:

(cd /path/to/src/dir && tar cf - .)|(cd /path/to/dst/dir && tar xpvf -)
 

Read other 3 answers
RELEVANCY SCORE 54

Converted an app from 95 to 97 but now I'm faced with a CommandBar/Menubar on top of my forms which I do not want. Does anybody know how to remove this?

In design or form view, the option to remove this by using Toolbars/Customise etc does nothing.

I have attched a bitmap showing the CommandBar/Menubar I'm trying to remove.

Any help greatly appreciated.

Warren.
 

A:How do I completely hide a command bar in Access 97

Are you talking about the thing that's right under the label saying "This is the command bar..."? With just the resize and close buttons on it? Just asking because that's a title bar, not a command bar. Which changes what you have to do: open the form in question in design view. Make sure the form properties window is visible. Find a property called Border Style, and set it to none.

I don't see any actual Access command bars or menu bars in your screen print.
 

Read other 1 answers
RELEVANCY SCORE 53.6

Every time i auto hide my taskbar i get this ugly white line as you see on the screenshot is there any program that disables this?

A:Remove white line from taskbar auto hide

I can't seem to see that white line but...

How About trying this:
Auto-hide off + Taskbar unlocked = white bar
Auto-hide off + Taskbar locked = no white bar
Auto-hide on + taskbar locked or unlocked = white bar

Read other 7 answers
RELEVANCY SCORE 53.2

I have a batch command to back up a subdirectory:
xcopy "C:\All\*" "E:\Allback\*" /E /Q

How can I hide the command window during the execution?

A:Batch file hide command window

Try this VBscript method (there's undoubtedly a PowerShell equivalent, too): How to run .BAT files invisibly, without displaying the Command Prompt window - The Winhelponline Blog.
--Ed--

Read other 0 answers
RELEVANCY SCORE 53.2

Just for fun i done this small modification from a internet tutorial,
Go to C:\Windows\Resources\Themes\(your theme folder)\Shell\NormalColor\
and backup your shellstyle.dll then replace wtih modded one.
Preview



Download Windows 8.1 shellstyle.dll Auto Hide Command Bar by drakulaboy on deviantART

A:Windows 8.1 shellstyle.dll Auto Hide Command Bar

thanks drakulaboy!

for those who want to remove command bar permanently i've made a small change to it, it's based on the tutorials which doesn't seem to work on win8 and on the drakulaboy's dll

shellstyle

Read other 2 answers
RELEVANCY SCORE 52.8

I want to create a button that will toggle hide files and folders. Or a shortcut say, or may be registry key change pair files.
Some folders such as svn are hidden, so I need to keep switching it off and on frequently. because i don't like to see those ini files and other system files.

Regards.

A:Hide files action button/shortcut/command ?

Hello Akshay, welcome to the Seven Forums.

Check the tip given in this post out: Hidden Files and Folders - Show or Hide

Kari

Read other 3 answers